|Date Posted:||Thursday, December 20th, 2018|
|Job Location:||Los Angeles, CA|
|Required Skills:||SQL DBA, SQL Database Administrator|
Why you want to work here:
The 5th largest Insurance Brokerage in the land.
Always have the opportunity to work with and integrate new technologies as the company grows and obtains and invests in other companies.
Work with a team that understands technology and runs their team as peers where everyone has a say.
What You Will Do
Support for 80 – 100 SQL Server instances in multiple data centers, including Development, Test, and Production Environment including both physical and virtual servers.
Perform SQL Server installations, configuration, upgrades, and latest patch applications.
Monitor database backup and restore processes, including daily/weekly maintenance jobs to ensure the data availability and work non-business hours for system emergencies, production database releases and data migrations with minimal or no impact to company operations.
Proactively watch and optimize any data replication/ETL processes.
Develop and maintain scripts to automate SQL administration tasks.
Troubleshoot and resolve database issues by optimizing T-SQL Code.
Plan, design and implement the database capacity, physical, and logical modeling/security practice for every phase of application development.
Work with vendors, application support, Infrastructure group and developers to meet the needs of database refresh in development/staging environment.
MS SQL Database development including designing, developing, testing and implementing databases, stored procedures, functions, triggers, indexes, and jobs.
Resolve complex database related issues & outages.
Act as the first technical contact for any query/database performance issues; assist developers and business power users in query requests and enhancements.
Ensure data object naming convention and enforce data integrity.
What Gets You the Job?
3 – 6 years of experience as a member of the DBA team
Hands-on experience in Database Administration field for SQL Server 2005-2014 in both physical and virtual environments
Strong experience with Backups, Restores, DMVs, DBCC commands, SQL Profiler, and PerfMon
Good Knowledge of High Availability, Always-On availability groups, Database Mirroring, Replication, Recovery Models, Policy Based Management, and SOX audit
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, diskspace, and other resource contention
Familiarity with Performance Tuning and Query Optimization
Experience in Security Administration, Index Management and statistics update
Experience with ELT process and development using SSIS
Understanding of SSAS and SSRS (development and deployment is a plus)
History with 3rd party backup and performance diagnosis and monitoring tools from IDERA and Solarwinds is a plus
Knowledge of Oracle and MySQL database/Architecture/Technologies is a plus
About Technical Connections, Inc.:
Technical Connections is Southern California’s premier recruiting firm specializing exclusively in web, software and information technology professionals. The firm, based in Los Angeles, offers a full range of services, including retained search, contingency placement, and short- and long-term consulting.
Technical Connections was established in 1984 by Helen MacKinnon, an executive with extensive technical and managerial experience in the computer industry. The firm, which initially focused on serving clients within the software development field, today works with companies in a variety of industries. Clients range from technology start-ups to multinational giants. Technical Connections places hundreds of candidates annually.
The counselors at Technical Connections do not consider themselves “headhunters,” but rather professional consultants whose in-depth knowledge of both technology and the marketplace enables them to offer candidates and clients a rare level of strategic counsel. MacKinnon, who has Master’s degrees in both Computer Science and Business Administration from the University of Southern California, recruits her internal staff based on their interpersonal skills as well as their technical and business expertise. Unlike many recruiters and temporary placement firms that have only recently entered the technical arena, Technical Connections has always specialized in this field.
TCI believes that when all employees have an ownership stake in their company, it is reflected in the quality of their work and therefore in the long-term success of the firm. At TCI, employees have an ownership interest in the firm through the Technical Connections Employee Stock Ownership Plan (ESOP). TCI contributes annually to a trust account for the benefit of the employees. The ESOP holds 100% of the voting stock of TCI.