Database Expert Job Description
As a Database Administrator, you will play a vital role in ensuring the sustainability and growth of an organization by supporting its Software Development capability.
Working closely with Product Managers and other Database Experts, you will be responsible for implementing, configuring, maintaining, and optimizing critical SQL Server RDBMS systems to ensure performance, security, and reliability.
Your Responsibilities
* Ensure optimal database performance, availability, security, and long-term sustainability.
* Identify and resolve issues in real time to keep systems running smoothly.
* Offer practical solutions and recommendations for continuous improvement.
* Automate routine processes, track issues, and document system changes.
* Support developers with query optimization and schema enhancements.
* Manage and optimize Power BI reporting in a cloud environment.
About You
* 4+ years hands-on experience in SQL Server Administration
* 2+years of experience with Performance Tuning and Optimization (PTO)
* Monitor and optimize database performance using index tuning, DVM, and other methods.
* Manage High Availability (HA) databases, database backups, and disaster recovery
* Design and develop SSIS packages for data transformation, loading, and extraction.
* Experience in supporting batch interfaces via SSIS.
* Create and implement database solutions (tables, stored procedures, etc.) and manage data migrations from legacy systems to new platforms.
* Experience in financial data reporting, data migrations, analysis, and standardization, with strong database design and SQL Server development skills.
* Knowledge of Amazon Aurora, RDS, Redshift, Dynamo DB, or MongoDB.
* Experience with DevOps, CI/CD pipelines, Agile processes, and tools like Visual Studio and SQL Server would be a plus.