Database Administrator
Role Summary:
As a Database Administrator, you will play a vital role in ensuring the sustainability and growth of our business by supporting our Software Development capability.
Responsibilities:
* Ensure optimal database performance, availability, security, and long-term sustainability.
* Identify and resolve issues in real time to maintain 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:
* You must have at least 4 years hands-on experience in SQL Server Administration.
* Two or more years of experience with Performance Tuning and Optimization (PTO).
* Experience with monitoring and optimizing database performance using index tuning, dvm, and other methods.
* Knowledge of managing 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.
* Knowledge of Amazon Aurora, RDS, Redshift, Dynamo DB, or MongoDB.
* Understanding of DevOps, CI/CD pipelines, Agile processes, and tools like Visual Studio and SQL Server would be beneficial.