IT and software engineering jobs in the US, Canada and the UK. It's extremely easy to apply for multiple jobs on our website. Please, check us out! ×


Applied: No

Date Posted: Friday, January 12th, 2024
Job Location: Los Angeles, CA
Pay Rate: 105K
Employment Type: Full-time
Job Duration: Permanent
Required Skills: SQL DBA, SQL Database Administrator

Job Description:

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:

Remote 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.

Special Locations:

Enter Silicon Valley or

San Francisco Bay Area

IT Jobs in Canada:

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

IT Jobs in the United Kingdom:

England – 59 jobs

Northern Ireland – 0 jobs

Scotland – 0 jobs

Wales – 0 jobs

IT Jobs in the United States:

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 – 152 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

Our commitment to job seekers

Job seekers, we're committed to making your job search experience a breeze. Please, note the following four things:

  1. We never ask you to register or fill out an application form with a million questions. Everything is in your resume, and if job posters have questions, they can and should follow up with an interview. That's what an interview is for!
  2. We never direct you to various third-party websites or Applicant Tracking Systems (ATS) where you have to register or fill out the same huge application forms again and again and again
  3. We use Ajax to submit your resume, and here's the zest of our website
  4. By default, we save your application information in local storage. If your cover letter is generic enough, you'll save a few keystrokes when you apply for another job!

It's extremely easy to submit your resume to multiple jobs on our website! Please, check us out and help spread the word about us!

Our domain name is easy to remember. Those who know C++, C# or Java will easily recognize the static keyword in our company name.

Now, if you're really brave, we encourage you to read about some serious problems this website addresses. These problems plague all niche job boards out there as well as the big guns in the recruitment industry. This is the most important part! Please, read it!

Online Application×
First Name: *
Last Name: *
Email Address: *

Cover Letter *

Resume *

Application Submitted
Click OK to close this message box
By the way, we save your application information in local storage by default. If your cover letter is generic enough, you'll save a few keystrokes when you apply for another job!
Unexpected Error
An unexpected error occurred while processing your request. Please, try again later or contact us for technical assistance.
Click OK to close this message box
Progress Indicator