Job Description

Our Enterprise Data & Shared Services team is seeking for a highly capable database administrator to support and maintain the daily activity of the database team related to different types of databases specially for DB2 You will be administering and implementing standardized database management procedures for databases To ensure success as a database administrator, you should possess extensive knowledge of database administration and experience in a similar role You will be working with a team of professionals to design and implement the best database practices for databases, provide guidance to database team on database structures and features You will create standard procedures to enhance scalability and performance of existing database architecture Troubleshoot complex database issues in accurate and timely manner Develop best practices for performance and operational efficiency This position offers adequate chances for personal and professional growth and development, while working with a multitalented and supportive team Your Role Accountabilities: Primarily responsible for administrating DB2 databases along with other types of databases like Postgres, MySQL Install, configure, upgrade, and manage databases Implement and enforce database security Participate in disaster recovery planning, testing and execution Apply patching and upgrade databases as per requirements Identify and resolve performance related queries Implement security, roles, users, and privileges using the best practices Provide database/objects recovery as need on basis Design, identify and implement high performing and highly available data warehouse solutions Proactively identify, design, and implement process improvements like automating manual processes, optimizing data flow etc Provide support for all staged of database implementation and/or database related deployments Stay up to date with the latest features and best practices Follow existing database runbooks, create, and maintain new runbooks for new and improved processes Provide 24X7 On-call support by participating in rotation schedule % Time Spent on The Daily XX%XX%Qualifications & Experiences: Bachelors degree in computer science, information systems, or information technology 10+ years of experience as a database administrator Minimum 5+ years of hands-on administration experience, from setting up the DB2 databases Experience with the various database platforms like SAP Hana, MySQL, PostgreSQL will be helpful as well Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Windows BAT, Python etc Experience with different monitoring tools like DBI, DataDog etc Some experience with AWS with knowledge of S3, EC2, IAM, Security, Lambda, Networking etc Ability and experience with the development of processes and procedures to standardize Database installations and configuration Extensive experience with implementation and maintenance of Disaster Recovery and High availability Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious Ability to provide technical documentation and project plans for technical staff members Excellent communication, presentation, and customer relationship skills Excellent organizational and time management skills to handle multiple tasks simultaneously Must have the legal right to work in the United States Ability to provide 24/7 support MAJOR DUTIES AND RESPONSIBILITIES To comply with the AMERICANS WITH DISABILITIES ACT OF 1990 (ADA) which prohibits discrimination against qualified individuals on the basis of disability, it is necessary to specify the physical, intellectual and environmental conditions of the Essential Duties of the job Please check all that apply Physical Intellectual EnvironmentalOn the job, the employee must: On the job, the employee must: On the job, the employee must: Bend Sit Read/comprehend Is exposed to excessive noise Squat Stand Write Is around moving machinery Crawl Walk Perform calculations Is exposed to marked changes in temperature and/or humidity Climb Push/Pull Communicate orally Is exposed to dust, fumes, gases, radiation, microwave (circle) Kneel Other: Drives motorized equipment Handle objects (manual dexterity) Works in confined quarters Reach above shoulder level Other: Use fine finger movements Other: Must carry/lift loads of: III DIMENSIONSWhere applicable, provide information about the size of the organization managed, operating budget, revenue accountability, or other quantitative data pertinent to this position QUANTITATIVE INFORMATION IV DECISION-MAKING AUTHORITYIf this job has managerial or supervisory responsibilities, please check all that apply ProvidesInput Into Recommendation Makes Recommendation Has Final Approval Not ApplicableHiring Setting work goals, objectives and standards to be achieved Establishing work unit budget Approving unbudgeted expenditures Approves salary changes for employees Counsels and disciplines employees Authorizing promotion, demotions or discharges

foundit