What are the responsibilities and job description for the Sr. SQL Server & Azure Database Administrator position at Seneca Resources?
Job Title: Sr. SQL Server & Azure Database Administrator
Location: Hybrid; New York, NY (3 days onsite, 2 remote)
Hours: 37.5/week (required 4 weeks unpaid vacation)
Duration: 12 Month Contract, likely extension
Pay range: $95/hr (W2), depending on experience
Interview: Could be onsite in New York, NY or remote via Teams (up to hiring manager). Likely 1-2 rounds of interviews
Our Government client located in New York, NY is seeking a Senior SQL Server & Azure Database Administrator to design, implement, administer, maintain, tune, and optimize mission-critical enterprise database environments.
This is a senior hands-on database engineering and administration role with a strong focus on Microsoft SQL Server, Azure SQL Managed Instance, Windows Server, high availability, database performance, security, backup/recovery, migrations, and automation. The DBA will be responsible for ensuring database platforms meet application availability, performance, security, and operational requirements while supporting both existing systems and future technology initiatives.
The successful candidate will collaborate closely with application development, infrastructure, systems administration, networking, help desk, and other technical teams. This individual will also help establish database standards and best practices, evaluate emerging technologies, engineer database solutions, and provide technical direction to less senior team members.
Key Responsibilities
SQL Server & Azure Database Administration
Design, implement, configure, administer, and maintain Microsoft SQL Server database environments.
Design, implement, and support Azure SQL Managed Instance environments.
Perform SQL Server and database installations, upgrades, migrations, configuration, and ongoing maintenance.
Administer database environments across enterprise infrastructure and cloud platforms.
Monitor database availability, health, capacity, and performance.
Troubleshoot and remediate complex database and infrastructure-related issues.
Support database requirements for enterprise software applications and systems.
Ensure database platforms meet established availability and performance objectives.
Azure Cloud & Infrastructure
Support database workloads within the Microsoft Azure cloud platform.
Administer and support technologies including Azure SQL Managed Instance, Azure Storage Accounts, and Azure security capabilities.
Collaborate with infrastructure teams on Windows Server and database platform requirements.
Coordinate regularly scheduled operating system and database patching activities.
Support database infrastructure across Windows and, where applicable, UNIX/Linux environments.
Work with systems and network administrators to coordinate infrastructure dependencies.
Evaluate new database and cloud technologies and provide recommendations regarding their potential use within the enterprise.
High Availability, Backup & Recovery
Design, implement, administer, and troubleshoot SQL Server Always On high-availability solutions.
Develop and maintain database backup and recovery strategies.
Establish backup schedules and perform verification and recovery testing.
Help ensure databases can meet business continuity and availability requirements.
Maintain supporting backup, recovery, and operational documentation.
Participate in database migration and infrastructure resiliency initiatives.
Performance Optimization & Troubleshooting
Monitor and optimize SQL Server database performance.
Perform SQL and query tuning to improve application and database performance.
Identify database bottlenecks and perform root-cause analysis.
Troubleshoot database, operating system, storage, connectivity, and application-related issues.
Analyze database workloads and recommend appropriate performance improvements.
Collaborate with application developers to optimize database interactions and application performance.
Provide both remote and onsite technical support when required.
Database Engineering & Architecture
Design and engineer database solutions and technical standards.
Perform database administration activities involving data modeling, data process flows, migrations, security, and performance tuning.
Configure and install database software, modules, and related applications.
Support database architecture and infrastructure planning.
Participate in technical evaluations of new database products and technologies.
Assess the potential operational impact of introducing new technologies into a large enterprise environment.
Contribute to the planning and coordination of database installations, upgrades, support, and maintenance activities.
Security & Compliance
Implement and maintain database security controls.
Help ensure database environments comply with organizational security policies and standards.
Support Azure and SQL Server security requirements.
Maintain accurate system, database, and operational documentation.
Ensure required records associated with database infrastructure and IT assets are maintained accurately and in accordance with established policies.
Collaborate with appropriate technical teams on security remediation and platform hardening.
Automation & Scripting
Develop and maintain scripts used to automate recurring database administration activities.
Use SQL and scripting/programming technologies to improve operational efficiency.
Support shell scripting used for database administration and automation.
Develop automation for database maintenance, monitoring, deployment, and administrative activities.
Apply general-purpose programming and scripting capabilities to database operational requirements.
Utilize Python for database or infrastructure automation where applicable.
Technical Leadership & Documentation
Develop and maintain database procedures, technical documentation, standards, and best practices.
Provide advanced technical direction to less senior database administrators and technical staff.
Guide team members in database installation, administration, troubleshooting, and maintenance activities.
Collaborate effectively with developers, systems administrators, network administrators, infrastructure teams, and support personnel.
Communicate technical issues, risks, and recommendations clearly to appropriate stakeholders.
Help establish consistent database engineering and operational standards across the organization.
Required Qualifications
5 years of hands-on experience as a Microsoft SQL Server Database Administrator.
8 years of experience installing, maintaining, administering, and supporting database products, operating systems, and related enterprise infrastructure.
Bachelor's degree in Computer Science, Information Technology, or a related discipline, or significant equivalent professional experience.
Strong hands-on expertise with Microsoft SQL Server.
Strong knowledge of Windows Server environments.
Strong experience with the Microsoft Azure cloud platform.
Hands-on experience with Azure SQL Managed Instance.
Knowledge of Azure Storage Accounts and Azure security fundamentals.
Experience implementing and supporting SQL Server Always On high availability.
Strong SQL skills, including database troubleshooting and performance/query tuning.
Experience with SQL Server installation, configuration, upgrades, and migrations.
Experience developing and implementing database backup and recovery strategies.
Experience with database security and enterprise compliance requirements.
Experience troubleshooting complex database and infrastructure issues.
Knowledge of database design, data modeling, migrations, and performance optimization.
Experience working with operating systems and infrastructure supporting enterprise database platforms.
Experience with scripting and database task automation.
Strong analytical and logical troubleshooting skills.
Strong written and verbal communication skills.
Ability to independently engineer solutions while providing technical direction to less experienced staff.
Critical Skills
Skill Area
Target Experience
Priority
Microsoft SQL Server Administration
6 years targeted
#1 – Critical
SQL Server DBA Experience
5 years minimum
#1 – Critical
Azure SQL Managed Instance
Hands-on
Critical
Microsoft Azure
Hands-on
Critical
SQL Server Always On / High Availability
Hands-on
Critical
SQL / Query Performance Tuning
Advanced
Critical
Backup & Recovery
Advanced
Critical
SQL Server Installation / Upgrades / Migrations
Advanced
Critical
Windows Server
Advanced
Highly Relevant
Database Security
Hands-on
Highly Relevant
Database Automation / Scripting
Hands-on
Highly Relevant
Preferred Qualifications
Microsoft database or Azure certifications.
Experience using Python for database administration or automation.
Advanced shell scripting experience.
Experience supporting databases across Windows, UNIX, and Linux operating environments.
Experience with Oracle databases in addition to Microsoft SQL Server.
Experience working with storage-area network technologies as they relate to database infrastructure.
Experience supporting large, complex enterprise environments.
Experience mentoring or providing technical direction to junior database administrators.
Experience developing enterprise database standards, procedures, and engineering documentation.
Technologies & Areas of Expertise
Microsoft SQL Server
Azure SQL Managed Instance
Microsoft Azure
Azure Storage
SQL
SQL Server Always On
High Availability
Database Performance Tuning
Query Optimization
Database Backup & Recovery
Database Migrations
Database Security
Windows Server
UNIX / Linux
Oracle
Python
Shell Scripting
Database Automation
Data Modeling
Storage Area Networks
Enterprise Database Architecture
What You'll Work On
You'll help maintain and evolve the database infrastructure supporting critical applications across a large, complex enterprise environment. Your work will span SQL Server and Azure database administration, cloud database infrastructure, high availability, migrations, performance tuning, security, backup and recovery, troubleshooting, and automation.
This position is best suited for an experienced, hands-on DBA who can do more than simply maintain databases. The strongest candidate will be capable of engineering database solutions, diagnosing complex performance and infrastructure problems, establishing standards, collaborating across technical teams, and providing technical leadership, with particularly strong expertise in SQL Server and Azure SQL Managed Instance.
Location: Hybrid; New York, NY (3 days onsite, 2 remote)
Hours: 37.5/week (required 4 weeks unpaid vacation)
Duration: 12 Month Contract, likely extension
Pay range: $95/hr (W2), depending on experience
Interview: Could be onsite in New York, NY or remote via Teams (up to hiring manager). Likely 1-2 rounds of interviews
Our Government client located in New York, NY is seeking a Senior SQL Server & Azure Database Administrator to design, implement, administer, maintain, tune, and optimize mission-critical enterprise database environments.
This is a senior hands-on database engineering and administration role with a strong focus on Microsoft SQL Server, Azure SQL Managed Instance, Windows Server, high availability, database performance, security, backup/recovery, migrations, and automation. The DBA will be responsible for ensuring database platforms meet application availability, performance, security, and operational requirements while supporting both existing systems and future technology initiatives.
The successful candidate will collaborate closely with application development, infrastructure, systems administration, networking, help desk, and other technical teams. This individual will also help establish database standards and best practices, evaluate emerging technologies, engineer database solutions, and provide technical direction to less senior team members.
Key Responsibilities
SQL Server & Azure Database Administration
Design, implement, configure, administer, and maintain Microsoft SQL Server database environments.
Design, implement, and support Azure SQL Managed Instance environments.
Perform SQL Server and database installations, upgrades, migrations, configuration, and ongoing maintenance.
Administer database environments across enterprise infrastructure and cloud platforms.
Monitor database availability, health, capacity, and performance.
Troubleshoot and remediate complex database and infrastructure-related issues.
Support database requirements for enterprise software applications and systems.
Ensure database platforms meet established availability and performance objectives.
Azure Cloud & Infrastructure
Support database workloads within the Microsoft Azure cloud platform.
Administer and support technologies including Azure SQL Managed Instance, Azure Storage Accounts, and Azure security capabilities.
Collaborate with infrastructure teams on Windows Server and database platform requirements.
Coordinate regularly scheduled operating system and database patching activities.
Support database infrastructure across Windows and, where applicable, UNIX/Linux environments.
Work with systems and network administrators to coordinate infrastructure dependencies.
Evaluate new database and cloud technologies and provide recommendations regarding their potential use within the enterprise.
High Availability, Backup & Recovery
Design, implement, administer, and troubleshoot SQL Server Always On high-availability solutions.
Develop and maintain database backup and recovery strategies.
Establish backup schedules and perform verification and recovery testing.
Help ensure databases can meet business continuity and availability requirements.
Maintain supporting backup, recovery, and operational documentation.
Participate in database migration and infrastructure resiliency initiatives.
Performance Optimization & Troubleshooting
Monitor and optimize SQL Server database performance.
Perform SQL and query tuning to improve application and database performance.
Identify database bottlenecks and perform root-cause analysis.
Troubleshoot database, operating system, storage, connectivity, and application-related issues.
Analyze database workloads and recommend appropriate performance improvements.
Collaborate with application developers to optimize database interactions and application performance.
Provide both remote and onsite technical support when required.
Database Engineering & Architecture
Design and engineer database solutions and technical standards.
Perform database administration activities involving data modeling, data process flows, migrations, security, and performance tuning.
Configure and install database software, modules, and related applications.
Support database architecture and infrastructure planning.
Participate in technical evaluations of new database products and technologies.
Assess the potential operational impact of introducing new technologies into a large enterprise environment.
Contribute to the planning and coordination of database installations, upgrades, support, and maintenance activities.
Security & Compliance
Implement and maintain database security controls.
Help ensure database environments comply with organizational security policies and standards.
Support Azure and SQL Server security requirements.
Maintain accurate system, database, and operational documentation.
Ensure required records associated with database infrastructure and IT assets are maintained accurately and in accordance with established policies.
Collaborate with appropriate technical teams on security remediation and platform hardening.
Automation & Scripting
Develop and maintain scripts used to automate recurring database administration activities.
Use SQL and scripting/programming technologies to improve operational efficiency.
Support shell scripting used for database administration and automation.
Develop automation for database maintenance, monitoring, deployment, and administrative activities.
Apply general-purpose programming and scripting capabilities to database operational requirements.
Utilize Python for database or infrastructure automation where applicable.
Technical Leadership & Documentation
Develop and maintain database procedures, technical documentation, standards, and best practices.
Provide advanced technical direction to less senior database administrators and technical staff.
Guide team members in database installation, administration, troubleshooting, and maintenance activities.
Collaborate effectively with developers, systems administrators, network administrators, infrastructure teams, and support personnel.
Communicate technical issues, risks, and recommendations clearly to appropriate stakeholders.
Help establish consistent database engineering and operational standards across the organization.
Required Qualifications
5 years of hands-on experience as a Microsoft SQL Server Database Administrator.
8 years of experience installing, maintaining, administering, and supporting database products, operating systems, and related enterprise infrastructure.
Bachelor's degree in Computer Science, Information Technology, or a related discipline, or significant equivalent professional experience.
Strong hands-on expertise with Microsoft SQL Server.
Strong knowledge of Windows Server environments.
Strong experience with the Microsoft Azure cloud platform.
Hands-on experience with Azure SQL Managed Instance.
Knowledge of Azure Storage Accounts and Azure security fundamentals.
Experience implementing and supporting SQL Server Always On high availability.
Strong SQL skills, including database troubleshooting and performance/query tuning.
Experience with SQL Server installation, configuration, upgrades, and migrations.
Experience developing and implementing database backup and recovery strategies.
Experience with database security and enterprise compliance requirements.
Experience troubleshooting complex database and infrastructure issues.
Knowledge of database design, data modeling, migrations, and performance optimization.
Experience working with operating systems and infrastructure supporting enterprise database platforms.
Experience with scripting and database task automation.
Strong analytical and logical troubleshooting skills.
Strong written and verbal communication skills.
Ability to independently engineer solutions while providing technical direction to less experienced staff.
Critical Skills
Skill Area
Target Experience
Priority
Microsoft SQL Server Administration
6 years targeted
#1 – Critical
SQL Server DBA Experience
5 years minimum
#1 – Critical
Azure SQL Managed Instance
Hands-on
Critical
Microsoft Azure
Hands-on
Critical
SQL Server Always On / High Availability
Hands-on
Critical
SQL / Query Performance Tuning
Advanced
Critical
Backup & Recovery
Advanced
Critical
SQL Server Installation / Upgrades / Migrations
Advanced
Critical
Windows Server
Advanced
Highly Relevant
Database Security
Hands-on
Highly Relevant
Database Automation / Scripting
Hands-on
Highly Relevant
Preferred Qualifications
Microsoft database or Azure certifications.
Experience using Python for database administration or automation.
Advanced shell scripting experience.
Experience supporting databases across Windows, UNIX, and Linux operating environments.
Experience with Oracle databases in addition to Microsoft SQL Server.
Experience working with storage-area network technologies as they relate to database infrastructure.
Experience supporting large, complex enterprise environments.
Experience mentoring or providing technical direction to junior database administrators.
Experience developing enterprise database standards, procedures, and engineering documentation.
Technologies & Areas of Expertise
Microsoft SQL Server
Azure SQL Managed Instance
Microsoft Azure
Azure Storage
SQL
SQL Server Always On
High Availability
Database Performance Tuning
Query Optimization
Database Backup & Recovery
Database Migrations
Database Security
Windows Server
UNIX / Linux
Oracle
Python
Shell Scripting
Database Automation
Data Modeling
Storage Area Networks
Enterprise Database Architecture
What You'll Work On
You'll help maintain and evolve the database infrastructure supporting critical applications across a large, complex enterprise environment. Your work will span SQL Server and Azure database administration, cloud database infrastructure, high availability, migrations, performance tuning, security, backup and recovery, troubleshooting, and automation.
This position is best suited for an experienced, hands-on DBA who can do more than simply maintain databases. The strongest candidate will be capable of engineering database solutions, diagnosing complex performance and infrastructure problems, establishing standards, collaborating across technical teams, and providing technical leadership, with particularly strong expertise in SQL Server and Azure SQL Managed Instance.
Salary : $95