Position: SQL DBA
Location: Remote
Type - Contract
Specific Duties, Activities, And Responsibilities
- Owning, tracking and resolving database related incidents and requests
- Ensuring the Performance and Stability of the RDBMS platforms
- Providing, reviewing and resolving service related alerts/reports for maintenance, capacity, performance, ETL status
- Diagnose and resolve database performance issues.
- Proactively monitor the system
- Deploy database change scripts in multiple environments
- Help evaluate new technologies for inclusion in the environment
Position Requirements
Education or Equivalent:
- BS in Computer Science or Information Systems or Equivalent Work Experience
Experience Or Equivalent
- 8-10+ years’ experience working on relational database platform with emphasis on VLDBs.
- On-call deployment and troubleshooting experience
- Experience with database design principles, including normalization and aggregation, for both on-line and data warehouse schemas to support the needs of application developers.
Knowledge, Skills, and Abilities Requirements: List unique knowledge, skills, or problem-solving requirements.
- Database Performance and Tuning
- Hardware analysis (Disk I/O, Network I/O, Processors, Memory)
- Database Configuration Management
- Database Capacity Planning and Monitoring
- Troubleshooting
- Wait State Analysis
- Database Backups/Restores Technologies
- Implementing New Database servers in a Virtual Environment
- Database Design Skills including Normalization and Data Warehouse design
- Strong TSQL skills
- Strong analytical skills
- Structured Troubleshooting Skills
- SQL Query Performance Tuning experience
- Log Shipping, Mirroring and Always-on technologies
- Replication
- Experience with Foglight and other 3rd party Monitoring Tools
- Experience in the healthcare industry, a plus
- Analyze, solve, and correct database issues in real time.
- Provide suggestions for solutions.
- Refine and automate regular processes.
- Track issues and document changes.
- Assist developers with query tuning and schema refinement.
- Minimize database downtime.
- Implement high-speed transaction recovery techniques
- Provide 24x7 on call rotation support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours
Toolset
- Microsoft SQL Server 2014 thru 2022
- Microsoft SQL Server 2017 Reporting Services (SSRS)
- Knowledge and experience with Transact SQL (stored procedure, trigger and constraint development)
- Azure Database
- MS-Windows
- Snowflake
Physical/Mental Requirements
- Ability to communicate clearly both verbally and in writing.
- Ability to analyze complex application and business operational issues.
- Critical thinking and problem-solving skills.
- Ability to work well in a team.
- Good time-management skills.