Database Administrator

Key Accountabilities
Database Administration and Maintenance:

• Install, configure, upgrade, and patch supported database systems (Oracle 10g–19c, PostgreSQL, or MS SQL Server).
• Perform database and schema refresh operations using native tools (e.g., Oracle exp/imp, Expdp/Impdp; pgdump/pgrestore; SQL Server backup/restore).
• Implement database change orders according to established schedules and procedures.
• Monitor database performance and availability using platform-specific tools (e.g., Oracle Enterprise Manager, pgAdmin, SSMS).
• Document database policies, procedures, and standards for organizational compliance.

Backup, Recovery, And Performance Management

• Execute backup, restore, and recovery operations using RMAN (Oracle), pgBackRest/Barman (PostgreSQL), or native SQL Server tools.
• Perform SQL tuning and indexing strategies to optimize query performance.
• Utilize performance monitoring tools such as AWR/ADDM (Oracle), pgstatstatements (PostgreSQL), or SQL Profiler (SQL Server).
• 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 as required.
• Participate in project meetings to provide database perspective and technical input.
• Support clinical research applications through reliable and secure database infrastructure.

System Integration and Technical Support

• Collaborate with IT teams to ensure 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.
• Ensure database systems meet availability and compliance requirements for clinical research operations.

Skills

• Proficiency in one of the following: Oracle RDBMS (10g–19c), 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.
• Ability to work under pressure during system outages.
• Customer service orientation when supporting internal users.

Knowledge And Experience

• 3–6 years of experience in database administration for one of the following: Oracle, PostgreSQL, or MS SQL Server.
• Experience with installation, upgrade, 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.

Education

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