POSITION OVERVIEW

Position Title:  Database Administrator (DBA)
Location: Princeton, NJ

In-person Interview Required

Key Responsibilities:

Backup, Recovery, and Performance Management

• Execute backup, restore, and recovery operations using RMAN (Oracle), native PostgreSQL, or native SQL Server tools.
• Perform SQL tuning and implement indexing strategies to optimize query performance.
• Utilize performance monitoring tools (AWR/ADDM, pgstatstatements, SQL Profiler) to proactively manage and resolve database issues.
• Troubleshoot database and performance issues to minimize system downtime.
• Maintain and support standby or high-availability configurations for disaster recovery.

Infrastructure Support and Collaboration

• Administer platform-specific technologies such as Oracle ASM/RAC, PostgreSQL replication, or SQL Server Always On Availability Groups.
• Perform basic system administration tasks on UNIX/Linux (Oracle/PostgreSQL) or Windows Server (SQL Server).
• Coordinate with system administrators, network teams, and backup teams for integrated support.
• Participate in project meetings, providing database perspective and technical input.

Cloud Database Management (AWS)

• Deploy, manage, and optimize database solutions on AWS, including Amazon RDS, Amazon Aurora, and EC2-hosted databases.
• Implement backup, recovery, and monitoring strategies for cloud-based databases.
• Ensure security, compliance, and high availability of cloud database environments.
• Collaborate with cloud engineering teams to integrate database systems with AWS infrastructure.

System Integration and Technical Support

• Collaborate with IT teams for seamless integration of database systems with enterprise applications.
• Provide technical expertise for database-related aspects of system implementations and migrations.
• Maintain database security and access controls in accordance with organizational policies.
• Support application teams with database connectivity and performance issues.

Basic Qualifications:

• Minimum 6 years of experience in database administration, with expertise in Oracle and at least one of PostgreSQL or MS SQL Server.
• Experience with installation, upgrades, patching, and migration processes.
• Hands-on experience with backup and recovery operations.
• Demonstrated experience in SQL performance tuning and optimization.
• Experience working in high-availability and disaster recovery environments.
• Knowledge of database refresh and migration procedures.
• Experience coordinating with system administration and network teams.
• Familiarity with operating systems relevant to the supported platform.
• Experience with AWS cloud database services (Amazon RDS, Aurora, EC2, etc.) and cloud migration processes.

Required Skills:

• Proficiency in Oracle RDBMS (19c) and at least one of PostgreSQL or MS SQL Server.
• Experience with monitoring and management tools relevant to the supported platform.
• Knowledge of backup and recovery procedures using platform-specific tools.
• Expertise in SQL tuning, indexing, and performance optimization.
• Familiarity with high-availability and disaster recovery technologies.
• Basic UNIX/Linux or Windows Server administration skills depending on platform.
• Strong analytical and troubleshooting abilities.
• Clear written and verbal communication skills.
• Ability to work collaboratively with cross-functional teams.
• Strong attention to detail and documentation practices.
• Time management and prioritization capabilities.
• Customer service orientation when supporting internal users.
• Experience with AWS cloud database management, security, and migration.

Education & Certifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field preferred.
• Relevant certifications such as Oracle Certified Professional (OCP), PostgreSQL certification, Microsoft SQL Server certifications, or AWS Certified Database/Solutions Architect preferred.