SCS Engineers is looking for an experienced Database Administrator to add to our development team. As a Database Administrator with strong SQL development skills, you will play a key role in driving enhancements to our software products as well as optimizing hardware resources. You will work both independently and as part of a collaborative team to ensure high-quality user experiences. With a passion for technology and software development, you will contribute to the success of the team by addressing data-intensive challenges, optimizing database performance, and delivering on multiple projects within varying timelines. You will also work closely with stakeholders to understand requirements, providing technical expertise to solve complex problems and improve overall software functionality. This position will be based in our Long Beach Headquarters and you can be hybrid (2 days/week in office) but we will consider remote candidates in the USA.
· Database Design & Architecture: Design, implement, and maintain database structures and schemas that support enterprise applications and business requirements.
· Database Performance Optimization: Monitor, diagnose, and optimize database performance to ensure high availability and efficiency of production databases.
· Backup and Recovery: Develop and manage comprehensive backup and recovery strategies to ensure data integrity, availability, and business continuity.
· Database Security: Implement and enforce database security measures, including user access control, encryption, and compliance with relevant security standards and regulations.
· SQL Development: Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and demonstrate SSRS skills to meet application and reporting requirements.
· Automation & Scripting: Develop scripts and automation tools for routine database administration tasks, such as backups, indexing, and monitoring. Participate in ETL operations to load and transform data as required.
· Database Upgrades & Patches: Plan, test, and execute database upgrades and patch management to ensure systems are up-to-date and secure.
· Incident Management & Troubleshooting: Respond to and resolve database-related incidents and performance issues in a timely and effective manner.
· Database Monitoring & Reporting: Utilize database monitoring tools to track system health, performance, and resource utilization; provide regular performance reports and recommendations.
· Collaboration with Development Teams: Work closely with software developers to ensure database design aligns with application requirements, providing guidance on data access and optimization techniques. Participate in code deployments as required.
· Documentation & Best Practices: Maintain comprehensive documentation of database systems, procedures, and configurations, and establish best practices for development, maintenance, and troubleshooting.
· Capacity Planning & Scaling: Proactively plan and manage database resources to support growth, including storage, memory, and compute requirements for database systems.