SQL DBA/Developer - KORE1 Technologies
Oxnard, CA
About the Job
KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a
SQL Server Database Administrator (DBA) and Developer
Essential Functions:
We are seeking a versatile professional who can seamlessly transition between the roles of MS SQL Server Database Administrator and Developer. The ideal candidate will be responsible for ensuring the stability, performance and security of SQL Server databases while also contributing to database design, backup and recovery strategies, installation of new releases and data modeling.
- Database Administration: manage and maintain SQL Server databases to ensure data integrity, high availability, and performance of the applications.
- T-SQL Programming: Develop, optimize, and maintain T-SQL scripts and stored procedures
- Data Design: Assist in the design and implementation of database schemas, ensuring efficient data storage and retrieval.
- Backup and Recovery: Develop and implement backup and recovery plans to safeguard data against loss and corruption
- Installation and Upgrades: handle the installation of new database releases and patches ensuring minimal disruption to operations.
- Performance Tuning: Monitor and tune database performance, including SQL Server configuration, indexes, and query execution plans.
- Security: Implement and manage database security measures, including user permissions and data encryption.
- Troubleshooting: Diagnose and resolve database access and performance issues
- Maintenance: Conduct regular database maintenance activities, such as index rebuilds, database reorganizations, and statistics updates. Sound better
- Documentation: Document database configurations, processes, and procedures to ensure knowledge transfer and continuity
- Modernization: Stay current with industry trends and best practices in MSC SQL Server administration and development
- a plus
Qualifications:
Education:
- Bachelors degree in Computer Science, Information Technology, or a related field
Experience:
- 3+ years of experience as a MS SQL Server Database Administrator
- 5+ I'm serious matter but years of experience as a MS SQL developer
- Strong proficiency in administering MS SQL Server databases (versions 2014 and above)
- Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Experience with database design, development, and optimizing using T-SQL
- Hands-on experience with database backup and recovery strategies
- Familiarity with database security best practices and principles
- Excellent problem-solving and troubleshooting skills
- Proven experience with database documentation including ERDs
- Strong communication and collaboration skills, with the ability to work effectively in a team environment
Preferred Qualifications:
- Local government or public sector experience especially public safety (police and fire)
- Experience with high availability and disaster recovery solutions and database mirroring
- Knowledge of performance tuning techniques and tools for MS SQL Server databases
- Experience managing all levels of data models: conceptual, logical, and physical
- Familiarity with cloud-based database solutions such as Azure SQL database or Amazon RDS
- Experience with other database solutions such as Oracle, DB2, or MySQL
- Relevant certifications such as Microsoft certified: Azure Database Administrator Associate or Microsoft certified: Data Management and Analytics are
ABOUT KORE1
Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.
Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.
Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Kore1 expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Kore1's employees to perform their job duties may result in discipline up to and including discharge.
Source : KORE1 Technologies