EXP: 4+ Years
Client: leading global biotechnology company for ICC and location is Bangalore
DBA responsible for contributing to and supporting the operation and maintenance of at least one of the following database platforms Oracle, SQL Server, Postgresql & mySQL. Ensuring security best practices across infrastructure and databases, including encryption, access controls, and vulnerability management. Key Responsibilities: Managing the performance, scalability, and security of databases, handling disaster recovery (DR),high availability (HA),backups, patching, and database automation. Monitor database performance and optimize queries, indexing, and storage structures. Analyze and resolve performance issues. Manage backup tasks to ensure data integrity and availability. Manage user access controls. Collaborate with development, DevOps, and infrastructure teams to ensure smooth integration of database systems with applications. Maintain detailed documentation of database configurations, maintenance schedules, security policies, and incident logs. Support database-related projects and initiatives. Implementing security measures for both automated infrastructure and database environments, automating vulnerability scans, and handling compliance. Ensure security best practices are followed in the development pipeline, including vulnerability scanning and automated security testing.
• Bachelor's or Master’s degree in Computer Science, Information Technology, or a related field. • 3-5 years of experience as a DBA, with a focus on enterprise-level systems • Experience supporting complex database projects and managing large databases (terabyte-scale). • Experience in database technologies (SQL/NoSQL) and any of the following platforms (Oracle, MySQL, MS SQL Server, PostgreSQL). • Proficency in query analysis, optimization, and index management to improve database performance. • Proficiency in scripting languages (e.g., PowerShell, Bash) to automate database tasks like backups and monitoring. • Knowledge of database security practices, including encryption, access control, and auditing. • Skills in supporting the designing and managing of high-availability and disaster recovery enabled database systems. • Able to collaborate with technical and non-technical teams, explaining complex database issues in simple terms. • Installation, configuration, and upgrading with either Oracle, MSSQL, PostgreSQL, and MySQL databases across multiple hosting platforms. • Performance tuning and optimization (SQL queries, indexes, storage optimization) across all database systems. • Database backup, recovery planning, and implementation using RMAN (Oracle),SQL Server Backup, pg_dump (PostgreSQL),and mysqldump. • Experience in High Availability (HA) and Disaster Recovery (DR) strategies, including Oracle RAC, MSSQL AlwaysOn, PostgreSQL replication, and MySQL clustering. • Database security management, including role-based access control, encryption, and auditing in Oracle, MSSQL, PostgreSQL, and MySQL. • Data migration and upgrade planning between database versions and across different database platforms (Oracle to MSSQL, MySQL to PostgreSQL, etc.). • SQL code review and development support for complex queries, stored procedures, functions, and triggers. • Management of large-scale databases, including partitioning (Oracle, MSSQL) and sharding (PostgreSQL, MySQL). • Database capacity planning and performance forecasting, ensuring adequate resources for future growth. • Experience in setting up and maintaining database monitoring tools such as Oracle Enterprise Manager, SQL Server Management Studio (SSMS),pgAdmin, and MySQL Workbench. • Database patch management and maintenance, applying updates and patches with minimal downtime. • Supporting development teams in Agile environments, collaborating on database design, development, and testing strategies. • Automating database administration tasks using shell scripts, PowerShell, or database-specific automation tools (Oracle SQL*Plus, PostgreSQL pgScript, etc.). • Experience with cloud-based database services (Oracle Cloud, AWS RDS, Azure SQL) for Oracle, MSSQL, PostgreSQL, and MySQL. • Participating and providing support for database architecture and administration planning activities.
1.The more the Jobs you apply, the higher your chances of getting a job.
2. Keep your profile updated Update
Recruiters prefer candidates with complete profile information.
3. Keep visiting the Teamlease.com daily
Daily visit will ensure you won’t miss out on any Job opportunity.
4. Watch videos to improve Watch videos
Be a better candidate than others by watching these Job-related videos.