MSSQL
Started: 9/1/2019
Duration: 660 months
I’m a MSSQL (Microsoft SQL Server) specialist who builds and maintains enterprise-grade databases for reliable, high-performance applications.
- Database Architecture & Design: Craft normalized schemas with well-defined tables, relationships, keys, and constraints to ensure data integrity and efficient storage.
- T-SQL & Query Performance: Develop advanced stored procedures, functions, and views; employ indexing strategies, execution-plan analysis, and query hints to slash response times.
- High Availability & Disaster Recovery: Configure Always On Availability Groups, failover clustering, and replication (transactional, merge) to guarantee continuous uptime and protect critical data.
- Monitoring & Optimization: Use SQL Server Profiler, Extended Events, and Database Engine Tuning Advisor to pinpoint bottlenecks and fine-tune system performance.
- Security & Compliance: Implement role-based access controls, Transparent Data Encryption (TDE), Always Encrypted columns, and auditing to safeguard sensitive information and meet regulatory requirements.
- Data Integration & BI: Design ETL pipelines with SSIS, build interactive reports using SSRS or Power BI, and enable real-time analytics for data-driven decision-making.
- Cloud & DevOps: Deploy and manage Azure SQL Database and Managed Instances; automate backups, schema migrations, and releases using Azure DevOps pipelines.
Key Skills: MSSQL · Microsoft SQL Server · T-SQL · Performance Tuning · High Availability · Replication · SSIS · SSRS · Azure SQL · Database Security · Data Warehousing
Used in These Jobs
- Software Developer & Systems Administrator
Lead developer and systems administrator for the Sentry Drug Testing Management Solution at Cordant Health Solutions, ov…