IBM Application Database Administrator: RDBMS in Pune, India
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
Work on triggering on both channel and application triggering by configuring channel initiators and trigger monitors
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
9+ years of DB administration including configuring, maintaining, optimising, upgrading, migrating of Oracle databasesExperience in DB clustering and RACMigration of Oracle database to Cloud Manged Services for eg RDSBasic Knowledge of Azure or AWS infrastructure automationExpertise in designing high availability and disaster recovery solutions for the databasesExpertise in performance tuning databases schemas, indexes and queriesSkills in scripting like PowerShell, Bash, Shell
Experience in Databases to be taken care are SQL Server 2012 to 2019, 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
About Business UnitIBM Services is a team of business, strategy and technology consultants that design, build, and run foundational systems and services that is the backbone of the world's economy. IBM Services partners with the world's leading companies in over 170 countries to build smarter businesses by reimagining and reinventing through technology, with its outcome-focused methodologies, industry-leading portfolio and world class research and operations expertise leading to results-driven innovation and enduring excellence.
Your Life @ IBMWhat matters to you when you're looking for your next career challenge?
Maybe you want to get involved in work that really changes the world? What about somewhere with incredible and diverse career and development opportunities - where you can truly discover your passion? Are you looking for a culture of openness, collaboration and trust - where everyone has a voice? What about all of these? If so, then IBM could be your next career challenge. Join us, not to do something better, but to attempt things you never thought possible.
Impact. Inclusion. Infinite Experiences. Do your best work ever.
About IBMIBM's greatest invention is the IBMer. We believe that progress is made through progressive thinking, progressive leadership, progressive policy and progressive action. IBMers believe that the application of intelligence, reason and science can improve business, society and the human condition. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 IBMers serving clients in 170 countries.
Location StatementFor additional information about location requirements, please discuss with the recruiter following submission of your application.
Being You @ IBMIBM is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.