SQL Database Administrator (SQL DBA)

Phaxis; New York (NY); On-site; USD 110,000 - 120,000; Full time

Job summary

Phaxis is seeking an experienced SQL Database Administrator (DBA) with strong skills in Microsoft SQL Server, Oracle Database, and AWS. This role supports enterprise applications, ensuring performance, security, and high availability across on‑premises and cloud environments.

You will drive HA/DR, backups, tuning, and migrations, collaborate with infrastructure and development teams, and automate tasks with PowerShell and T‑SQL.

Qualifications

• Bachelor's degree or equivalent professional experience in CS/IT or related field.
• 5+ years of hands-on Microsoft SQL Server administration in enterprise environments.
• Strong experience with Oracle Database administration.
• Hands-on experience managing databases in AWS (RDS, EC2, S3).
• Experience with SQL Server Always On, Failover Clustering, Oracle Data Guard, and DR planning.
• Advanced knowledge of T-SQL and PL/SQL.
• Experience in performance tuning, monitoring, and capacity planning.
• Experience implementing backup, recovery, and security best practices.
• Familiarity with Windows Server and Linux.
• Experience with database monitoring and administration tools.
• Strong troubleshooting, analytical, and problem-solving skills.
• Excellent communication and collaboration in fast-paced environments.

Responsibilities

• Install, configure, administer, and maintain Microsoft SQL Server and Oracle databases.
• Monitor health, performance, and availability; proactively resolve issues.
• Perform upgrades, migrations, and version upgrades.
• Implement HA/DR using SQL Server Always On, Failover Clustering, and Oracle Data Guard.
• Develop and optimize T-SQL and PL/SQL; create procedures and views.
• Tune performance, indexing, and execution plans.
• Design backup/recovery procedures for business continuity.
• Manage AWS-hosted databases (RDS, EC2, S3) and related services.
• Plan migrations between on-premises and AWS.
• Enforce security, encryption, access control, auditing.
• Automate tasks with PowerShell, T-SQL, SQL Agent.
• Collaborate with dev, infra, cloud teams for deployments.
• Maintain database documentation and standards.
• Participate in production support, incident response, on-call rotations.

Skills

Troubleshooting

Analytical thinking

Communication skills

Team collaboration

Education

Bachelor's degree in CS/IT or related field

Tools

Microsoft SQL Server

Oracle Database

AWS (RDS, EC2, S3)

PowerShell

T-SQL

PL/SQL

SQL Server Always On

Failover Clustering

Oracle Data Guard

Job description

We are seeking an experienced SQL Database Administrator (DBA) with strong skills in Microsoft SQL Server, Oracle Database, and Amazon Web Services (AWS). This role is responsible for the administration, performance, security, and availability of enterprise database environments supporting critical business applications. The ideal candidate will have hands-on experience managing both on-premises and cloud-based database platforms, implementing high availability and disaster recovery solutions, and collaborating with infrastructure and application teams to optimize database performance.

Key Responsibilities

Salary is 110k to 120k + bonus

• Install, configure, administer, and maintain Microsoft SQL Server and Oracle database environments.
• Monitor database health, performance, and availability while proactively identifying and resolving issues.
• Perform database installations, upgrades, patches, migrations, and version upgrades.
• Configure and support high availability and disaster recovery solutions, including SQL Server Always On Availability Groups, Failover Clustering, Oracle Data Guard, and backup/recovery strategies.
• Develop and optimize T‑SQL, PL/SQL, stored procedures, functions, views, and database objects.
• Perform database performance tuning, query optimization, indexing, and execution plan analysis.
• Design and implement backup, recovery, and disaster recovery procedures to meet business continuity objectives.
• Administer databases hosted in AWS, including Amazon RDS for SQL Server and Oracle, Amazon EC2, EBS, S3, and related cloud services.
• Plan and execute database migrations between on-premises and AWS cloud environments.
• Implement database security, encryption, user access management, auditing, and compliance best practices.
• Automate administrative tasks using PowerShell, T‑SQL, SQL Agent Jobs, or other scripting tools.
• Collaborate with development, infrastructure, and cloud engineering teams to support application deployments and database changes.
• Create and maintain database documentation, standards, and operational procedures.
• Participate in production support, incident response, root cause analysis, and on‑call rotations.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent professional experience.
• 5+ years of hands‑on experience administering Microsoft SQL Server in enterprise environments.
• Strong experience administering Oracle Database.
• Hands‑on experience supporting databases in AWS, including Amazon RDS, EC2, S3, IAM, CloudWatch, and related services.
• Experience with SQL Server Always On, Failover Clustering, Oracle Data Guard, and disaster recovery planning.
• Advanced knowledge of T‑SQL and PL/SQL.
• Experience with database performance tuning, monitoring, and capacity planning.
• Experience implementing database backup, recovery, and security best practices.
• Familiarity with Windows Server and Linux operating systems.
• Experience with database monitoring and administration tools.
• Strong troubleshooting, analytical, and problem‑solving skills.
• Excellent communication skills and the ability to work collaboratively in a fast‑paced environment.