Database Engineer

Job Summary

5+ years of experience in Database Engineering, Administration, and Architecture, with strong technical leadership and enterprise database governance expertise.

Responsibilities

• Design and implement enterprise-grade OLTP, OLAP, hybrid, and distributed database architectures using SQL Server, MySQL, PostgreSQL, and other database technologies.
• Define database standards, naming conventions, data modeling practices, and architectures using sharding, partitioning, and federation strategies.
• Design and maintain normalized, denormalized, dimensional, Star, Snowflake, and Data Vault schemas, including ER diagrams and data dictionaries.
• Develop and optimize T-SQL, PL/SQL, and PL/pgSQL objects including stored procedures, functions, triggers, and views.
• Perform advanced performance tuning and query optimization using execution plans, wait statistics, SQL Profiler, Extended Events, EXPLAIN ANALYZE, and advanced indexing strategies.
• Manage database security, users, roles, permissions, locking, concurrency, deadlocks, blocking chains, and least-privilege access controls.
• Design and manage backup, restoration, point-in-time recovery, disaster recovery, and high-availability solutions, including Always On AG, clustering, replication, and log shipping.
• Manage cloud database platforms and PaaS services, including scaling, elastic pools, rightsizing, storage optimization, and cost management; experience with Windows/Linux, VMware, and DevOps environments.
• Strong expertise in Git, SVN, Liquibase, Flyway, Redgate, database governance, troubleshooting, RCA, reliability, scalability, security, and stakeholder collaboration.

Qualifications

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.