Database Adminitrator

**Position Name -** **Database Administrator**

**Location -** **HSR layout-Bangalore (WFO)**

**Experience -** **Min. 3 yrs**

**Mandatory Requirement**:

- Responsible for the design, implementation, maintenance, and optimization of our databases.
- Strong SQL skills and ability to write complex SQL queries and stored procedures.
- A minimum of 3+ years of experience as a Database Administrator

**About the client**:
Client is a Technology driven organization founded in 2016 ISO 9001 & 27001 certified, delivering the best possible services powered by technology using AI and ML Modules with the team that works closely with their clients to understand their requirements and provide them with customized solutions that deliver value.

Their Services include: Business Process Management: They manage the Data & Voice Processes in the Title/Mortgage Services in the Mortgage Business. Background Verification Services: Screenate is an in-house tool developed by the client for verification / screening services across industries for individuals / corporate. Building Information Modeling: They provide Modeling Services (CAD2BIM, SCAN2BIM, CIVIL3D, MEP, and Rendering) BACS: Business Process Consulting and Automation Services.

**Job Role and Responsibilities**:

- Database design and implementation: Collaborate with development teams to understand database requirements and design efficient and scalable database structures. Implement and configure databases, ensuring proper indexing, partitioning, and data distribution for optimal performance.
- Database management: Monitor and manage database performance, capacity, and availability. Perform regular database maintenance tasks such as backups, restores, and data migrations. Continuously monitor and optimize database performance through performance tuning and query optimization techniques.
- Database security and integrity: Implement and enforce database security measures, including user access controls, authentication, and data encryption. Monitor database activity for potential security threats and promptly address vulnerabilities. Ensure data integrity through appropriate data validation and data cleansing techniques.
- Database troubleshooting and support: Investigate and resolve database-related issues, such as data corruption, performance bottlenecks, and connectivity problems. Collaborate with development teams and system administrators to diagnose and resolve database-related incidents and outages.
- Database documentation: Create and maintain database documentation, including data dictionaries, schema diagrams, and standard operating procedures. Document database configurations, backup and recovery procedures, and security policies.
- Database optimization and performance tuning: Identify and address database performance issues through performance monitoring, query optimization, and index tuning. Recommend and implement database schema changes and optimization strategies to improve overall system performance.
- Database backup and recovery: Develop and implement database backup and recovery plans to ensure data availability and minimize data loss. Test and verify database backups regularly and perform data recovery operations when necessary.
- Database upgrades and migrations: Plan and execute database upgrades, patches, and migrations while minimizing downtime and ensuring data integrity. Coordinate with development teams to perform schema changes and ensure compatibility with new software releases.
- Database monitoring and reporting: Monitor database systems for performance, availability, and security. Set up and maintain database monitoring tools and generate regular performance and usage reports for management and stakeholders.
- Collaboration and communication: Collaborate effectively with cross-functional teams, including developers, system administrators, and business stakeholders. Communicate technical concepts and solutions clearly to both technical and non-technical audiences.

**Qualifications**:

- Education: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. Relevant certifications in database administration (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator) are advantageous.
- Experience: A minimum of 3+ years of experience as a Database Administrator or in a similar role, managing and optimizing databases in a production environment.
- Strong database management skills: In-depth knowledge of database management systems (e.g., Oracle, MySQL, SQL Server, PostgreSQL) and their principles, architecture, and best practices. Proficiency in database design, performance tuning, backup and recovery, and data integrity.
- SQL proficiency: Strong SQL skills and ability to write complex SQL queries and stored procedures. Familiarity with query optimization techniques and performance tuning.
- Database security and compliance: Experience in implementing database security measures, such