Posted: 17-Mar-23
Location: Irvine, California
Type: Full Time
Salary: $125K to $135K
Categories:
Preferred Education:
Internal Number: VN369
Primary role of the Senior DBA is to effectively manage the MSSQL Server & Oracle database instances and automation of database related processes. Experience with Cloud platforms like AWS & Azure and Knowledge of NOSQL databases like MongoDB and willingness to expand into non-relational data domains is a strong plus.
What you will do and achieve:
- Database software installation, configuration and patching.
- Ensure databases availability and integrity.
- Institute reliable backup/recovery processes and SOPs.
- Strong ability to debug/troubleshoot code issues and write efficient and scalable code
- Monitor databases performance and perform database tuning.
- Lead database related projects and effectively manage cross team collaboration for timely delivery.
- Proactively provide transparency in work progress.
- Management of large & complex Spatial databases.
Who you are:
Education
- Bachelor’s Degree in Computer Science or related field of study.
- Industry recognized certifications are a plus.
Experience
- At least 3+ years of proven experience in database administration.
- Database processes streamlining & automation.
- Troubleshooting database performance and providing remediation.
- Work organization and reporting skills utilizing tools like Jira/Teams to provide transparency.
Key Knowledge & Skills
- Database design.
- Database engine internals.
- Database Coding – Procedures, Scripts, Functions etc.
- Python or Shell programming.
- Experience with Data migration.
- GIS skills a plus.
Core Competencies
- Able to work in fast-paced, deadline-driven environment and to flexibly manage multiple priorities.
- Implement best-practices in process and coding standards.
- Documentation and change management. Enable easy review of database processes and modifications.
- Strong ability to debug/troubleshoot code issues and write efficient and scalable code. .
- Strong understanding of the hardware & storage technologies to optimize database availability and performance.
- Experience with Linux, RMAN
Other Desirable Attributes
- Outstanding leadership, teamwork, and organizational skills.
- Excellent listening, interpersonal, written, and oral communication skills.
- Excellent problem-solving ability.
- Experience with NOSQL technologies.
LightBox's Diversity Commitment
LightBox is fully committed to employing a diverse workforce and creating an inclusive work environment that embraces everyone’s unique contributions, experiences, and values. We believe in unity in diversity and offer a collaborative work environment that encourages creativity, initiative and professional growth and provides a competitive salary and benefits package. ? We are better together when we support, recognize, and embrace our differences.
This job description is a general listing of the required tasks and expectations of the position and in no way implies that the duties listed above are the employee’s only responsibilities. The employee is expected to perform other tasks, responsibilities and training as instructed by their supervisors. Duties and responsibilities may change at any time with or without notice.
This position may require additional hours outside of the standard work schedule including occasional holiday, evening and/or weekend hours in order to meet deadlines or to accommodate customers.
LightBox and all its holding companies are an equal opportunity/affirmative action employer. It is the policy of the LightBox and its holding companies to prohibit discrimination of any type and to afford equal employment opportunities to employees and applicants, without regard to race, color, religion, sex, national origin, age, disability, or veteran status.
NO TELEPHONE CALLS OR AGENCY SOLICITATION PLEASE.