Database Administrator

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

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.