Database Administrator & SQL Developer

Role & responsibilities

• Database Administration Skills, Knowledge of Datawarehouse / Data Lake, Good SQL Development skills
• Working knowledge of Tables, Views, Schemas, Procedures, functions, triggers, CTE, Cursor, security (encrypt / decrypt), logs, data structures, database sizing, data integration and migration strategies, Import - Export
• Managing and tracking successful database software Installation, Patch Management and Maintenance
• Developing, managing, monitoring and maintaining data ETL and ELT jobs on Microsoft SQL Server and Oracle databases
• Working knowledge of Azure Data Factory & Synapse
• Working knowledge of data warehousing and data mining
• Should be able to initiate, execute, monitor database admin related activities in coordination with different software vendors
• Managing regulatory defined specific data handling based on nature of data and security requirements, example: PII data
• Developing, managing, monitoring and tracking database Backups and Recovery
• Managing and administrating both on-premise and Cloud databases and/or integrations within them
• Devising, monitoring and tracking database and data access Security mechanism for companys business software databases
• Managing and controlling the Authentication and authorization of data from company databases
• Responsible for Capacity Planning for any requirements related to data
• Continuously monitoring database servers performance and security, finding opportunities for improving implementations and performance
• Troubleshooting any database related issues and solving if possible else engaging vendor to resolve the same

Preferred candidate profile:

Relevant Years of Experience: 5 - 8 yrs.

Qualification: Any master’s or bachelor’s degree in IT Computer stream, Database Admin certification (desirable).

Industry Experience: Good to have knowledge of Housing Finance / BFSI / NBFC Secured Loan workflow process.