Job Description

Roles & Responsibilities

Database Administration & Management:

Install, configure, and maintain Microsoft SQL Server environments (multiple versions).

Manage and administer PostgreSQL databases in production and development environments.

Provide basic administration support for Oracle databases (secondary responsibility).

Monitor database performance, identify bottlenecks, and implement tuning improvements.

Manage database backup, recovery, and disaster recovery (DR) strategies.

Manage and support database environments hosted on cloud platforms, ensuring performance, availability, security, and cost optimization.

Perform regular health checks and ensure high availability.

Maintain database security, including user roles, permissions, and access control.

Ensure compliance with internal IT policies, security standards, and audit requirements.

SQL Development & Optimization:

Design, develop, and optimize stored procedures, functions, views, and complex SQL queries.

Perform query tuning and execution plan analysis to improve performance.

Support application teams with efficient database design and query logic.

Maintain and optimize database indexing strategies.

Implement database auditing and logging mechanisms.

Data Integration & ETL:

Design and support ETL processes for data migration, transformation, and integration.

Work with ETL tools (e.g., SSIS or equivalent) to manage data pipelines.

Ensure data accuracy, consistency, and integrity across systems.

Support integration between ERP systems, data warehouse, and other applications.

Assist in building data feeds for reporting tools such as Power BI.

Monitoring & Operations:

Monitor database servers, jobs, and scheduled tasks.

Troubleshoot and resolve database-related incidents within SLA.

Review logs, disk usage, and system performance metrics.

Coordinate with infrastructure teams for storage, backups, and server performance.

Ensure database environments (Dev/UAT/Prod) are aligned and consistent.

Support & Collaboration:

Provide database support for ERP systems and other enterprise applications.

Assist developers in database-related issues and performance tuning.

Coordinate with vendors for database-related support and upgrades.

Participate in system upgrades, migrations, and implementation projects.

Provide after-hours support when required.

Documentation & Governance:

Maintain up-to-date database documentation (architecture, configurations, procedures).

Document backup, recovery, and DR procedures.

Ensure proper change management and version control for database objects.

Support audits and compliance reviews related to databases.

Security & Data Governance Collaboration:

Work closely with the Cybersecurity / SOC team to identify, assess, and remediate database-related vulnerabilities.

Support vulnerability assessments, penetration testing activities, and ensure timely closure of database security findings.

Implement database security best practices including patching, encryption, auditing, and access control.

Participate in security incident response activities related to database systems.

Contribute to Data Warehouse initiatives, supporting:

Data governance frameworks and standards

Master data management (MDM) practices

Data quality and consistency across systems

Design and understanding of data marts and data models

Collaborate with Data Warehouse and BI teams to ensure proper data structuring, transformation, and availability.

Vendor & Contract Management (Database Domain):

Act as the focal point for all database-related vendors, tools, and software solutions.

Coordinate with vendors for support, maintenance, upgrades, and issue resolution.

Manage and track database-related contracts, licenses, and renewals (e.g., SQL Server, PostgreSQL tools, monitoring solutions).

Support the evaluation, selection, and implementation of new database technologies and tools in alignment with business requirements.

Ensure all vendor activities comply with organizational policies, security standards, and governance frameworks.

Work closely with procurement and IT management on database-related purchases and initiatives, providing technical input and recommendations.

Monitor vendor performance and ensure adherence to agreed SLAs and support commitments.

Day-To-Day Operations:

Monitor and maintain the performance, availability, and overall health of the database systems, primarily Microsoft SQL Server and PostgreSQL, ensuring optimal functionality across production, UAT, and development environments.

Execute, analyze, and continuously optimize complex SQL queries, stored procedures, functions, and views to support business applications, reporting requirements, and data integration processes.

Proactively review database logs, job executions, and system resource utilization (CPU, memory, disk space), taking corrective actions to prevent performance degradation or system failures.

Manage and monitor database backup processes, restoration procedures, and scheduled maintenance activities, ensuring data integrity and readiness for disaster recovery scenarios.

Handle database user management activities, including creation, modification, and revocation of access rights, while ensuring compliance with security policies and segregation of duties.

Collaborate closely with the Cybersecurity (SOC) team to monitor, assess, and remediate database-related vulnerabilities, participate in security incident investigations, and ensure timely application of patches and security controls.