SQL Database Administrator
Location
Secunderabad | India
Job description
We are Alter Domus. Our name means 'The Other House' and we're a world leading provider of integrated solutions for the alternative investment industry. We believe in being different. Here, you progress on merit, not who you know. You speak openly, whoever you're speaking to. And it's your freedom to decide which cutting-edge kind of finance professional you want to be. Join more than 4,100 fund administration, accounting, tax, loan administration and legal experts worldwide and take pride in being alternative.
Alter Domus clients include the world's leading asset managers, lenders and asset owners. We're specialists who use the most innovative technologies to create unparalleled solutions for the private equity, real assets and debt capital markets sectors. This is where standout talent advances what's possible in fund administration, corporate services, depositary services, transfer pricing, domiciliation, management company services, loan administration, agency services, trade settlement and CLO manager services.
Alter Domus India develops and licenses a growing family of proprietary software products and service solutions to assist financial institutions with a number of complex topics such as accounting for credit deteriorated assets and the administration of investments in leveraged loans.
In addition to competitive compensation and benefits, we provide excellent opportunities for growth and learning and invest in our people's professional development.
Responsibilities:
- Partner with development teams to design data management and governance solutions.
- Understand how overall application strategy and business needs cascade to the database level.
- Design, configure, implement, and administer all databases in various environments (Development, QA, Production).
- Work on database performance optimization and query tuning.
- Identify performance bottlenecks, slow queries, and optimize it.
- Monitor server analytics (database memory, system resources, storage usage, available free space and consumption trends and provide notifications when identified thresholds are expected to be exceeded).
- Contribute to the implementation and testing of CI/CD pipelines.
- Proactively identify and resolve all issues related to database systems to ensure that systems are performing in line with business expectations and without service interruption.
- Build and manage the database disaster recovery and backup plans.
- Create and maintain stored procedures, views, tables, jobs, triggers, collections etc.
- Develop new and enhance existing standards, processes and procedures, and guidelines for database environments using industry experiences, best practices research, and business needs.
- Analyze and report the performance of database operations against the key database performance metrics.
- Contribute to a positive team attitude.
Qualifications
- 3+ experience with Microsoft SQL Server versions 2008 through SQL Server 2019.
- Experience working on databases that are hosted on-prem as well as the Azure cloud (PaaS and SaaS implementations).
- Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler/Extended events/Query store and other related monitoring and troubleshooting tools.
- Experience in troubleshooting and resolving blocking and deadlocking issues
- Advanced T-SQL skills
- Expert knowledge of DMVs, System Stored Procedures, User Defined Functions, and Custom Types
- Advanced knowledge of SQL Server's 'AlwaysOn' Availability Group.
- Experience with backups, restore and recovery models.
- Expert understanding of SQL Server security at both server and database levels
- Advanced knowledge and demonstrated ability in Query / Index tuning using Performance monitor statistics
- Strong experience developing stored procedures, functions, and views.
- Demonstrated ability to document findings and results, and present to customers.
- Excellent communication, presentation, and customer relationship skills.
- Work timings 2pm-11pm IST
Job tags
Salary