DataBase Administrator-DB2 MS-SQL
IBM
- Heredia
- Permanente
- Tiempo completo
As a SRE Engineer, you will work in an agile, collaborative environment to build, deploy, configure and maintain systems for the IBM client business. In this role, you will lead the problem resolution process for our clients, from analysis and troubleshooting, to deploying workarounds or fixes. Working closely with our worldwide teams, you will have a unique opportunity to gain first-hand experience with the latest technologies and be supported by a global team of IBMers to grow your own technical skills and develop your career. This role may require some attention after normal working hours in order to troubleshoot and resolve production issues experienced by clients. This role may also require shifting working hours as needed basis for follow-the-sun coverage.Your Role and Responsibilities
Conduct day to day continuous administration of databases such as relational databases including DB2 on Linux-Unix-Windows, MS-SQL server Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering Create, change, and improve SQL Server Agent tasks and maintenance plans Download and install SQL Server service packs and updates.Troubleshoot application sluggishness and poor performance.
Administer DB2 utility and application framework and building solution for DB2.
Install, upgrade and patch production DB2 databases. Install, upgrade, patch DB2 utility application framework products.Required Technical and Professional ExpertiseConduct performance tuning of high scale databases and clustered applications, fixing the issues reported in systems within the service level agreement as required.Experience with at least one major public cloud provider or large scale private/hybrid cloud using container orchestration.Experience with a modern configuration management framework (Puppet, Ansible, Chef, etc.)Utilize: DB2 database administration, DB2 utility framework, Java, DB2 high availability and disaster recovery, Automation, Kubernetes, Devops concepts and Cloud administration.Understanding of software development life cycle and delivery process.Ability to manage multiple projects, while ensuring that commitments and timetables are met.
Ability to partner with internal stakeholders to design operational solutions.
Goal oriented, forward thinker that can provide solutions for complex technical problems.
Demonstrated skills in leadership, communication, coaching, analysis, problem solving and short term and long-term planning."Preferred Technical and Professional Expertise
- Production DB2 LUW experience strongly preferred.
- Experience with change management workflows, JIRA, GitHub.
- Experience with SSAS, SSIS, and SSRS • Extensive knowledge of SQL and SQL server tools.
- Experience with SQL and/or NoSQL datastores (DB2 LUW, MSSQL, Oracle data services).