Senior Database Specialist

The Senior Database Specialist will be responsible for designing, developing, optimizing, and maintaining enterprise-level database systems using Microsoft SQL Server and Oracle Database
. The role requires strong expertise in database development, performance tuning, data modeling, and troubleshooting complex data-related issues. The ideal candidate will work closely with architects, backend developers, data teams, and system administrators to ensure high availability, data integrity, and optimal performance across all database environments.

• Design and develop database schemas, tables, views, stored procedures, functions, triggers, and packages in SQL Server and Oracle.
• Develop complex SQL queries and PL/SQL/T-SQL scripts to support application logic and reporting needs.
• Implement ETL/ELT processes for data integration and transformation.
• Create logical and physical data models aligned with business and system requirements.
• Design efficient indexing strategies, partitioning, and data distribution models.
• Implement best practices for relational database design, normalization, and data integrity.

• Analyze and optimize SQL queries, execution plans, and database workloads.
• Monitor system performance, identify bottlenecks, and apply tuning techniques.
• Implement caching, connection management, and optimization strategies.

• Install, configure, and upgrade SQL Server and Oracle database environments.
• Manage backup/restore strategies, replication, high availability (
  Always On, Data Guard, etc.).
• Apply patches, manage user permissions, and ensure database security.
• Conduct capacity planning and storage management.

• Diagnose and resolve database-related issues in development, testing, and production environments.
• Provide 3rd line support (
  L3
  ) for critical incidents affecting applications and data pipelines.
• Work with Dev Ops to support CI/CD processes for database deployments.
• Prepare and maintain database documentation including design diagrams, deployment guides, and operational procedures.
• Collaborate with cross-functional teams to ensure database standards and best practices are adopted.
• Participate in architecture and design reviews to ensure efficient database integration.

Minimum 8 years of experience in database development and administration using:

• Microsoft SQL Server (T-SQL, SSMS, SSIS, Always On, SQL Agent
  )
• Oracle Database (
  PL/SQL, SQL
  * Plus, Data Guard, RMAN, OEM
  )

• Query optimization and performance tuning
• Stored procedure and package development
• Backup/restore strategies
• High availability and disaster recovery configurations
• Security, roles, and permissions management

• ETL tools and data integration pipelines
• Cloud databases (
  Azure SQL, Oracle Cloud
  ) is a plus.
• Linux/Windows environments for database hosting.

• Strong analytical and problem‑solving abilities.
• Excellent communication and documentation skills.
• Ability to work under pressure with complex production systems.
• Collaborative mindset with ability to support developers and architects.

• Oracle Certified Professional (
  OCP
  )
• Experience with large‑scale enterprise systems and mission‑critical environments.
• Experience with data warehousing, BI platforms, and analytics solutions.