Description

• Tune PostgreSQL and MSSQL databases on AWS and Azure to reduce cost.

• Support all activities associated with PostgreSQL and MSSQL databases.

• Support the production environment by proactively managing the performance, integrity, and security of all applications' databases and database servers.

• Design, create and maintain highly available and secure database instances.

• Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.

• Mentor and provide support to developers in best practices for database design, programming, and tuning.

• Responsible for database administration including database system architecture, configuration, database creation, security, performance tuning and monitoring, backup and recoveries, database replication, failover strategies, data partitioning and scripting.

• Conversant with AWS RDS, Aurora, and Microsoft SQL Servers.

• May write PL/SQL code to load, migrate, summarize, and analyze data in support of application developers and other business objectives.

• Consult with developers to optimize query performance and provide best practice.

• Prepare / review implementation plans for major code pushes on production systems.

• Document all changes, upgrades, maintenance, and procedures following controls.

• Analyze products and recommend to senior management.

• Participate in an on-call rotation that provides 24x7x365 support of critical systems.

• Plan growth and changes (Capacity planning) on servers and databases

• Work closely with other team members for effective IT operations and business continuity

• Provide an effective Disaster Recovery strategy for the infrastructure on AWS and Azure

2. Competencies:

• Analytical – collects and researches data; uses intuition and experience to complement data.

• Design – demonstrates attention to detail.

• Problem solving – identifies and resolves problems in a timely manner; gathers and analyzes information skillfully; develops alternative solutions; works well in group problem solving situations; uses reason even when dealing with emotional topics.

• Oral Communication – speaks clearly and persuasively in positive or negative situations; listens and gets clarification; responds well to questions.

• Written Communications – writes clearly and informatively; able to read and interpret written information.

• Teamwork – contributes to building a positive team spirit; supports everyone’s efforts to succeed.

• Planning/Organizing – prioritizes and plans work activities; uses time efficiently; sets goals and objectives.

• Adaptability – adapts to changes in the work environment; manages competing demands; changes approach or method to best fit the situation; able to deal with frequent change, delays, or unexpected events.

Requirements

Microsoft SQL, PostgreSQL, MySQL PostgreSQL

3. Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made upon request to enable individuals with disabilities to perform the essential functions.

Required Skills/Experience:

• Minimum of 7 years Postgres DBA experience in an enterprise environment

• Bachelor’s degree in computer science or comparable education and experience

• Strong SQL background and demonstrable ability to optimize complex SQL queries

• AWS RDS, Aurora, SQL Server, PostgreSQL, and MySQL

• Experience with Unix or Linux, and Cloud Infrastructure.

• Language Skills

Ability to read, analyze, and interpret general business periodicals, professional journals, or governmental regulations. Ability t

Technology Doesn't Change the World, People Do.®

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.

All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

© 2024 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https:///www.roberthalf.com/us/en/terms) .