Job Location: 9070 Irvine Centre DR, Suite 220, Irvine, CA -92618
Essential Functions:
• Installation of MS SQL Server (2014, 2016) and Oracle Databases
• Serve as SME on MS SQL databases
• Maintaining production databases, which includes MS SQL, Oracle, and PostgreSQL
• Monitoring database efficiency
• Ensuring space availability
• Develop, test and manage backup and recovery plans
• Sustaining the security and integrity of data
• Supporting application deployments
• Monitor performance of DB to provide fast query responses to users
• Ensure that storage , archiving, backup and recovery procedures are functioning correctly
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security
• Create/modify PL/SQL packages and procedures
• Create shell scripts to execute PL/SQL commands that send dumps and logs and schedule them in cron
• Perform database backup and recovery, DB account creation, modification, deletion, DB shutdown and restart.
• Perform database upgrade and migration of SQL Server, Oracle, Postgres and MySQL DBs
Qualifications and Education Requirements:
• Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job plus two (2) years of experience.
• Experience may substitute for education for up to (4) years
• Strong knowledge of relational databases, backup and restore operations, replication, locking, mirroring, clustering, DB logins/permissions, stored procedures, schema, triggers, database maintenance activity, etc.
• Deep experience in the evaluation and implementation of database architectures, keys, and indexes that maximize system performance
• Deep experience with Performance Tuning and Optimization (PTO), using native monitoring and third-party troubleshooting tools
• Experience with database security, including account administration, password policy, data encryption, network encryption, and firewall rules
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Proven ability to collaborate with, learn from, and educate other experienced team members