|Date Posted:||Thursday, December 21st, 2017|
|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.
Browse IT Jobs by location:
Alberta – 11 jobs
British Columbia – 10 jobs
Manitoba – 0 jobs
New Brunswick – 0 jobs
Newfoundland and Labrador – 0 jobs
Northwest Territories – 0 jobs
Nova Scotia – 0 jobs
Nunavut – 0 jobs
Ontario – 13 jobs
Prince Edward Island – 0 jobs
Quebec – 0 jobs
Saskatchewan – 0 jobs
Yukon – 0 jobs
England – 58 jobs
Northern Ireland – 0 jobs
Scotland – 0 jobs
Wales – 0 jobs
Alabama – 2 jobs
Alaska – 1 job
Arizona – 4 jobs
Arkansas – 14 jobs
California – 100 jobs
Colorado – 16 jobs
Connecticut – 8 jobs
Delaware – 2 jobs
District of Columbia – 15 jobs
Florida – 31 jobs
Georgia – 13 jobs
Hawaii – 2 jobs
Idaho – 2 jobs
Illinois – 14 jobs
Indiana – 9 jobs
Iowa – 8 jobs
Kansas – 1 job
Kentucky – 4 jobs
Louisiana – 4 jobs
Maine – 0 jobs
Maryland – 11 jobs
Massachusetts – 43 jobs
Michigan – 6 jobs
Minnesota – 11 jobs
Mississippi – 0 jobs
Missouri – 5 jobs
Montana – 0 jobs
Nebraska – 1 job
Nevada – 1 job
New Hampshire – 1 job
New Jersey – 48 jobs
New Mexico – 2 jobs
New York – 151 jobs
North Carolina – 17 jobs
North Dakota – 0 jobs
Ohio – 18 jobs
Oklahoma – 2 jobs
Oregon – 26 jobs
Pennsylvania – 22 jobs
Rhode Island – 3 jobs
South Carolina – 4 jobs
South Dakota – 0 jobs
Tennessee – 3 jobs
Texas – 48 jobs
Utah – 8 jobs
Vermont – 0 jobs
Virginia – 19 jobs
Washington – 31 jobs
West Virginia – 0 jobs
Wisconsin – 5 jobs
Wyoming – 0 jobs
To search for remote jobs, enter optional keywords followed by Remote.
To search for remote jobs in a specific country, add that country. For example, Remote UK.