Database Administrator

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 company's 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: 6 - 10 yrs.

Job Types: Full-time, Permanent

Pay: ₹2,000,000.00 - ₹2,400,000.00 per year

Benefits:

• Health insurance
• Paid sick time
• Provident Fund

Experience:

• Database development: 5 years (Required)

Location:

• Bengaluru, Karnataka (Required)

Work Location: In person