Job
Description
Core Responsibilities: Design and maintain scalable and efficient database schemas based on business and application needs. Develop, optimize, and troubleshoot SQL queries, stored procedures, functions, and triggers. Create and manage tables, indexes, and relationships; maintain deployment scripts with support for versioning and rollback. Collaborate with API developers by providing required database support, including dummy data, data cleanup scripts, and performance insights. Assist ETL and Development teams involving databases such as Oracle, MySQL, Sybase, and SQL Server. Perform database maintenance tasks: backups, restores, indexing, statistics updates, and performance tuning. Ensure data security, integrity, and compliance with organizational policies. Maintain clear and up-to-date documentation for schemas, procedures, and deployment processes. Stay informed of industry trends and proactively suggest improvements or new tools. Required Qualifications: 34 years of hands-on experience with Microsoft SQL Server (2016 or later). Strong knowledge of T-SQL: scripting, stored procedures, views, functions, and triggers. Experience in data modeling, normalization, and schema design. Familiarity with CI/CD practices related to database deployment (e.g., upgrade/rollback scripts). Exposure to data migration projects involving multiple RDBMS platforms (e.g., Oracle, MySQL, Sybase). Experience collaborating with cross-functional teams (developers, QA, DevOps). Preferred/Bonus Skills: Working knowledge of MongoDB: schema design, indexing, aggregations. Experience with performance tuning, execution plans, and database optimization strategies. Familiarity with automation/scripting tools (PowerShell, Python, etc.) for database tasks. Understanding of database security, access control, and auditing. Exposure to backup and high-availability strategies (e.g., Always On, Log Shipping, Mirroring). Experience working with cloud-based databases (e.g., Azure SQL Database, Amazon RDS, MongoDB Atlas). Soft Skills: Strong analytical and troubleshooting abilities. Excellent communication and documentation skills. Ability to work independently and in team settings. Organized, detail-oriented, and proactive in identifying areas for improvement.
