Application Database Administrator| Rdbms

Introduction At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk. Your Role and Responsibilities - Perform installation, configuration and up gradation of Database on all environment - Implement distributed queuing on various platforms and clustering mechanism to reduce the administrative tasks - Manage database objects like table space, user, table, Index, roles, privileges, profiles, DB Links, materialized views, partitioning, synonyms, sequences, views and indexes and other database objects etc - Create physical/logical standby database and performing switch-over and fail-over - SQL DBA will manage the day to day admin related work of the SQL databases health checking and resolution of issues, upgrade database version, perform backup and recovery, reorg of databases, good understanding of different DR process, deep knowledge of ITIL process (Incident/Change/Problem) - Configure and maintain database servers and processes - Perform scheduled maintenance and support release deployment activities Required Technical and Professional Expertise - ++ years of DB administration including configuring, maintaining, optimising, upgrading, migrating of Oracle databases Experience in DB clustering and RAC Migration of Oracle database to Cloud Manged Services for eg RDS Basic Knowledge of Azure or AWS infrastructure automation Expertise in designing high availability and disaster recovery solutions for the databases Expertise in performance tuning databases schemas, indexes and queries Skills in scripting like PowerShell, Bash, Shell - Experience in Databases to be taken care are SQL Server 2012 to 2026, MySQL, Azure Postgres, Azure SQL - Proficient in Backup and Recoveries - Maintenance jobs like index rebuilding, statistics updates. - Experience in extensive use of native DR features - Monitoring methodologies to make sure critical databases are available 24x7 throughout the year - Solid troubleshooting experience of Database Engine issues, queries, performance and general health checks, Day to day operations, Audit Compliance, Deployments, Offshore - Technology: SQL Server, MySQL, Postgres, Azure SQL - Skills: -Installation (Cluster and Standalone), Maintenance, Troubleshooting, Backup and Recoveries, Monitoring, Auditing, DR Preferred Technical and Professional Expertise NA About Business Unit IBM Consulting is IBM’s consulting and global professional services business, with market leading capabilities in business and technology transformation. With deep expertise in many industries, we offer strategy, experience, technology, and operations services to many of the most innovative and valuable companies in the world. Our people are focused on accelerating our clients’ businesses through the power of collaboration. We believe in the power of technology responsibly used to help people, partners and the planet. In a world where technology never stands still, we understand that, dedication to our clients success, innovation that matters, and trust and personal responsibility in all our relationships, lives in what we do as IBMers as we strive to be the catalyst that makes the world work better. Being an IBMer means you’ll be able to learn and develop yourself and your career, you’ll be encouraged to be courageous and experiment everyday, all whilst having continuous trust and support in an environment where everyone can thrive whatever their personal or professional background. Our IBMers are growth minded, always staying curious, open to feedback and learning new information and skills to constantly transform themselves and our company. They are trusted to provide on-going feedback to help other IBMers grow, as well as collaborate with colleagues keeping in mind a team focused approach to include different perspectives to drive exceptional outcomes for our customers. The courage our IBMers have to make critical decisions everyday is essential to IBM becoming the catalyst for progress, always embracing challenges with resources they have to hand, a can-do attitude and always striving for an outcome focused approach within everything that they do. Are you ready to be an IBMer? About IBM Restlessly reinventing since 1+11, we are not only one of the largest corporate organizations in the world, we’re also one of the biggest technology and consulting employers, with many of the Fortune 50 companies relying on the IBM Cloud to run their business. At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing and blockchain. Now it’s time for you to join us on our journey to being a responsible technology innovator