Job Description:
This role develops solutions within our client's predefined database architecture. This position works closely with application developers to identify needs and set up appropriate pipelines to maintain the effectiveness and efficiency of the database. The engineer is responsible for functions and automation that pertain to development, analysis, performance tuning, and modeling of data.
Accountabilities:
Automates the creation and maintenance of databases for all environments.
Provides primary DB support for implementing, upgrading, and maintaining the DBMS (Oracle) environments.
Develops modern technologies and techniques to optimize database stability, resilience, and security.
Monitors and resolve application connectivity and DB interface issues; proactively working with other support teams to ensure that application problems do not adversely affect production operations.
Collaborates with application developers and vendors to report and resolve problems.
Implements and tests database backup and recovery technology / procedures for database environments.
Mentors and educates technical staff, DB users and vendors in techniques to optimize query performance.
Ensures compliance of all DB security standards in collaboration with IS&T Security Management.
Debugs problematic database issues, provide analysis for future enhancements and development; proactively maintaining effective and efficient database structures and system processing.
Forecasts and analyzes future capacity needs and develops tools and utilities to mitigate future capacity issues.
Required Qualifications:
4-year college degree in Computer Science, Math, Engineering, or related field OR 3+ years IT related experience
Self-learner with desire to solve difficult problems.
2+ years' experience SQL and PL/SQL or T-SQL programming
2+ years' experience with Unix shell, Perl, or OS scripting language
2+ years' experience with performance tuning
Strong knowledge of operating systems (i.e., Windows, Linux)
Excellent oral and written communication skills
Experience doing database backup and recovery.
Available to work outside normal business hours, including weekends and be on-call (7 days x 24 hours)
Effectively use Microsoft tools, including Outlook, Word, Excel, Visio, and PowerPoint
Preferred Qualifications:
2+ years' experience with DevOps or database administration
Experience creating DevOps and Automation (i.e., Ansible, Jenkins, Git) solutions.
Experience with OpenShift
Experience with Liquibase
Experience with Azure Public Cloud
Experience working in an agile/scrum environment.
Administration of Oracle Exadata appliance.
Oracle Certified Professional - OCP DBA Professional
Experience with MySQL and Microsoft SQL Databases
Q Consulting is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to disability, age, race, color, religion, gender, vet status, national origin, or protected classes.
#J-18808-Ljbffr
