Senior Database Administrator

Jobtailor; Town of Florida (NY); On-site; USD 110,000 - 170,000; Full time

Job summary

Jobtailor is seeking an experienced SQL Server Administrator to manage production and development environments, ensuring high availability and performance. You will design and implement database solutions, automate tasks with PowerShell or Python, and contribute to DR planning and data lake integration in a hybrid cloud setting.

Strong scripting and SQL optimization skills are required, with focus on PHI security and cross-team collaboration.

Qualifications

• Bachelor's degree or equivalent experience in a technical field.
• Minimum 5 years of enterprise Microsoft SQL Server administration experience.
• Ability to create/optimize stored procedures, functions, views, indexes, and query plans.
• Strong understanding of multi-tier applications and networks.
• Experience with high availability, failover clusters, and Always On availability groups.

Responsibilities

• Administer and maintain MS SQL Server across production and development environments.
• Design, implement, and optimize database solutions with data lake storage and analytics integration.
• Automate routine tasks using PowerShell and Python.
• Monitor performance, capacity, and security; provide key statistics.
• Plan and test disaster recovery including backups and restores.
• Collaborate across teams to ensure reliable, compliant enterprise systems.

Skills

Database Administration

Database Design & Architecture

Scripting Languages

High Availability

Data Lake & Analytics

Education

Bachelor of Science in CS/IS or related

Tools

PowerShell

Python

AWS

Job description

• Administer and maintain MS SQL Server across production and development environments.
• Recommend, design, and build out of new database systems cluster and high availability groups.
• Design and implement database solutions integrated with modern data lake storage and analytics platform.
• Automate routine administrative tasks using scripting languages (PowerShell/Python).
• Identify tools and resources to monitor SQL Server activity and provide key statistics and performance measures.
• Analyzes and troubleshoots problems related to SQL Server Environment.
• Maintains SQL Server plans for DR planning and business continuity including backup verification and restore testing.
• Designs and documents database architecture and standards.
• Perform capacity planning and forecasting to meet growing business and data demands.
• Design, recommend and implement appropriate storage to ensure optimum performance and availability of all database servers.
• Provide 24/7 support for critical situations.
• Develops security measures and policies for SQL Server to prevent unauthorized access.
• Protect personal health information (PHI) while fulfilling the above duties and responsibilities.

Requirements

• Bachelor of Science degree in Computer Science, Information Systems, or a related technical field or equivalent experience.
• At least five years of experience in administration of Microsoft SQL Server at an enterprise level.
• Ability to create and optimize stored procedures, functions, views, indexes, and query optimization plans.
• Strong understanding of complex networking and multi-tier applications and databases.
• Experience designing enterprise systems for high performance, availability, and reporting servers/architecture is required.
• Proficiency in scripting languages, such as PowerShell or Python, is essential for automation.
• You should also be comfortable working in hybrid cloud environments; AWS database services are preferred.
• A strong understanding of database monitoring, alerting, and capacity management tools.
• Experience with Windows Server failover clusters, Microsoft SQL Server Failover Clusters, MS SQL Server Always on Availability Groups, load balancing, and other high availability strategies is preferred.
• Amazon's AWS relational database products experience preferred.
• Data Lake and analytics experience preferred.
• Taking initiative, being accountable, and meeting deadlines are all important components of demonstrating ownership of projects.
• Excellent analytical and problem-solving skills.
• Able to approach work with attention to detail and focus on the product roadmap.
• Able to build and maintain effective working relationships in a team environment, with a diverse group and across functional areas.
• Demonstrates the ability for clear and effective verbal and written communications; demonstrates active listening skills.
• Proficient in English.

Core Competencies

Demonstrates expertise in administering and maintaining Microsoft SQL Server, including designing high availability systems and automating tasks with scripting languages. Proficient in database architecture, security measures, and performance optimization in hybrid cloud environments.

Highest-signal resume keywords

• Microsoft SQL Server Administration
• Database Design and Architecture
• Scripting Languages (PowerShell, Python)
• High Availability Strategies
• Data Lake and Analytics Integration

ATS Optimization Keywords

Hard Skills

• SQL Server Administration
• Stored Procedures Optimization
• Database Monitoring Tools
• Capacity Planning
• Backup Verification and Restore Testing
• Windows Server Failover Clusters
• AWS Database Services
• Query Optimization
• Database Security Measures
• High Availability Groups

Soft Skills

• Analytical Skills
• Problem-Solving Skills
• Attention to Detail
• Effective Communication
• Team Collaboration

Industry Keywords

• Business Continuity
• Personal Health Information (PHI)
• Enterprise Systems
• Multi-Tier Applications
• Load Balancing

Tools & Technologies

• MS SQL Server
• PowerShell
• Python
• AWS
• Data Lake Storage