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.