Database Designer & Administrator

Job Summary

We are seeking an experienced Database Designer & Administrator to design, implement, optimize, and maintain enterprise database environments supporting mission-critical applications and large-scale data platforms. The successful candidate will be responsible for logical and physical database design, performance optimization, database administration, and ensuring compliance with globally recognized database standards and best practices.

The ideal candidate will have extensive experience managing large datasets, optimizing SQL performance, supporting ETL/ELT processes, and administering enterprise database platforms such as Oracle, PostgreSQL, MySQL, or equivalent database technologies.

Key Responsibilities

Database Design

• Design and develop logical and physical database models based on business and technical requirements.
• Create efficient database schemas, tables, indexes, views, stored procedures, and relationships.
• Ensure database designs are scalable, secure, and aligned with enterprise architecture standards.
• Apply globally recognized database design standards and best practices.

Database Administration

• Install, configure, administer, and maintain enterprise database environments.
• Manage database availability, performance, scalability, and reliability.
• Perform database upgrades, patching, backup, recovery, and disaster recovery planning.
• Monitor database health and proactively resolve performance and operational issues.

Performance Optimization

• Analyze and optimize SQL queries, stored procedures, and database workloads.
• Perform query tuning, indexing strategies, and database performance optimization.
• Monitor database performance metrics and implement continuous improvements.
• Troubleshoot database bottlenecks and optimize resource utilization.

ETL/ELT & Data Integration Support

• Support ETL/ELT processes by optimizing database performance and ensuring efficient data loading.
• Collaborate with Data Engineers and ETL developers to improve data integration workflows.
• Ensure data integrity, consistency, and quality throughout database operations.
• Assist with data migration, transformation, and synchronization activities.

Security & Compliance

• Implement database security controls, user access management, encryption, and auditing.
• Ensure compliance with organizational security policies and industry standards.
• Maintain backup, recovery, and business continuity procedures.
• Perform regular database health checks and security assessments.

Documentation & Collaboration

• Maintain database architecture documentation, data models, operational procedures, and configuration records.
• Collaborate with software developers, data architects, infrastructure teams, and business stakeholders.
• Provide technical guidance and support for database-related initiatives.
• Participate in database modernization and continuous improvement projects.

Required Technical Skills

• Database Design (Logical & Physical Data Modeling)
• Database Administration
• SQL Development & Query Optimization
• Performance Tuning
• Database Security & Access Management
• Backup & Recovery
• Disaster Recovery Planning
• ETL/ELT Support
• Data Migration & Integration
• Database Monitoring & Troubleshooting
• Large Dataset Management
• Data Modeling Tools
• Linux/Windows Server Administration (Preferred)
• Scripting (Shell, Python, or PowerShell)

Database Technologies

• Oracle Database
• PostgreSQL
• MySQL
• Microsoft SQL Server (Preferred)
• MariaDB (Preferred)
• NoSQL databases (MongoDB, Cassandra, etc.) – Preferred

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field.
• Minimum 7+ years of experience in database design, database administration, and enterprise data management.
• Proven experience managing large-scale databases and optimizing SQL performance.
• Experience supporting ETL/ELT processes and enterprise data integration platforms.