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.
Location: Jersey City, NJ
Posted: Sept. 9, 2024, 9:42 a.m.
Apply Now Company Website