Job Description

Position: Sr. DBA / Lead Database Administrator Experience: 7-10 years Job Location: Bangalore / Chennai / Pune Position Type: Full time Qualification: Any graduate About the Role: Encora is seeking a Database Administrator, or DBA responsible for ov

Position: Sr. DBA / Lead Database Administrator Experience: 7-10 years Job Location: Bangalore / Chennai / Pune Position Type: Full time Qualification: Any graduate About the Role: Encora is seeking a Database Administrator, or DBA responsible for overseeing the performance and security measures of client and market facing databases, data products and data services. Technical Skills: SQL DBA, Log shipping, Mirroring, SQL, T-SQL, AZURE SQL, Database design, triggers, Procedures, debugging and tuning SQL Responsibilities Perform Storage and Compute Analysis, Quantification and Forecasting Perform Data architecture, logical and physical design Contribute to management and reliability of database HA/DR processes Contribute to management and reliability of cyber security and data security policy Contribute to configuration and tuning of databases, data platforms Demonstrate deep expertise in SQL based platforms Demonstrate deep expertise in Cloud storage and compute management Contribute to preservation of data integrity, security, and availability Monitor and contribute to management of ethically handling private data Familiarity with data privacy and security standards as they apply to the financial services industry Required Experience: 8+ years of experience as SQL DBA with experience and Always On setup Excellent knowledge of relational database design concepts, coding of functions, triggers and procedures, debugging and tuning SQL Knowledge and experience working with SQL Server databases, including advanced SQL and T-SQL Develop SQL stored procedures, views and optimize SQL processes in SQL Server Expertise in database administration and maintenance, monitoring the performance of databases and ensure it is operating at the optimum level. Experience working with SQL Server installation/upgrading procedures Knowledge of setting clustering, tuning, troubleshooting of Performance tuning, SQL Backup & Recovery Well-versed with the creation of SSIS, SSRS packages for data migration. Familiar with the creation of in-memory tables and Stored Procedures and natively compiled SQL queries Knowledge of Windows / Linux operating systems, cluster, components and configuration. Mongo DB and MYSQL Experience is must. Experience with SQL replication technology. Additional Skills/Knowledge: Knowledge of modern/evolving data architecture and database design theories Knowledge of database structure languages, such as SQL or SQL/PSM Expertise in server/serverless platform installation/configuration and performance management Familiarity with database management, data privacy and security best practices Able to extend beyond office hours for Support calls Able to work on US hours.