JobWatch

22 days old

SQL Server DBA Onsite San Diego, CA

Kelly Services
San Diego, CA 92108
**SQL Server DBA Onsite San Diego, CA**


**Contract to Hire**


**Summary:**


Under supervision from the IT Manager of Business & Information Systems the SQL Server DBA will provide the organization with an advanced level of expertise in Microsoft SQL server support, design and maintenance.


The SQL Server DBA shall be knowledgeable in the principles, procedures, and standards of Microsoft SQL operations, including performance tuning and database optimizations. This position will be responsible for daily operations of the MS SQL 2008, 2012 & 2016 environments.


The corporate database environment also utilizes MarkLogic Server, Oracle Database Server, MySQL, and Microsoft Access. Experience in these technologies, especially MarkLogic, would be considered a plus.


**Responsibilities:**


+ Troubleshoot day to day database and application issues.

+ Provide input into standards and procedures for monitoring, capacity planning, maintenance, backups and recovery.

+ Support multiple databases in development, staging and production environments in both local and remote data centers.

+ Configure and support high availability for SQL Server; to include clustering, replication, DB mirroring and Availability Groups.

+ Apply patches and upgrades.

+ Create and implement best practices for stored procedures, triggers, packages, tables, and views

+ Optimize database performance by analyzing and tuning stored procedures, creating indexes and views, etc. as needed under ITIL guidelines.

+ Create and maintain enterprise ETL processes using various ETL tools, such as SSIS, .NET Scripting, and T-SQL.

+ Complete database maintenance procedures and generate system reports

+ Provide on call support 24/7 in rotation with other members of the database administrators for MS SQL databases.

+ Create and implement security models

+ Create and support both SQL Reporting Services and SQL Analysis Services.


**Primary Responsibilities:**


Participation: Participate in application development processes to facilitate good database design and access techniques.


Support: Support application teams and resolve database problems.


Software Installation: Install server-based applications software in coordination with system administrators. Install new software, upgrades, and patches.


Backup and Recovery: Plan, prepare and test backup and recovery procedures for all production databases.


Database Tuning: Monitor databases for efficiency. Periodically reorganize databases for optimal performance during scheduled down time. Create indices and manipulate tuning parameters where needed to enhance performance.


Capacity Planning: Calculate volumetric equations to estimate new database sizes and plan appropriately for growth. Communicate plans to system administrators.


Security: Responsible for the security of database systems and all business/scientific applications connected to it. This includes creating and maintaining database and application accounts, application/database patching, and database/application security auditing.


Monitoring: Product monitoring for performance and health, participate in load test activities.


**Experience and Educational Requirements:**


1. 5+ years of MS SQL DBA experience.

2. Ability and willingness to provide quality customer service.

3. Effective organizational and interpersonal skills.

4. Experienced with T-SQL, SSIS, .NET Scripting (C# or VB.NET) and PowerShell.

5. ITIL Foundation certification a plus.

6. Experience with BigData / NoSQL Systems or Concepts considered a plus.

7. Experience as a Production DBA.

8. Troubleshoot and resolve database problems.

9. Ability to configure, migrate and maintain MS SQL implementations on Windows Server OS

10. Familiar with SQL reporting services configuration, report deployment & troubleshooting.


If you are interested in this role, then please feel free to reach out directly to: **vidhi.kundalia@kellyit.com** or 720-201-3798


**You should know:** Your safety matters! Vaccination against COVID-19 may be a requirement for this job in compliance with current client and governmental policies. A Kelly recruiter will confirm and share more details with you during the interview process.


**Why Kelly** **** **?**


By partnering with Kelly Technology, youll have direct connections to top companies around the globegiving you the chance to put your tech skills to work on some of todays most intriguing, innovative, and high-visibility projects. In a world where change is the only constant, our unparalleled connections and IT market expertise help you take your skills exactly where you want to go. Were here to help you gain experience, keep learning, and move your career forward.


**About Kelly** ****


At Kelly, were always thinking about whats next and advising job seekers on new ways of working to reach their full potential. In fact, were a leading advocate for temporary/nontraditional workstyles, because we believe they allow flexibility and tremendous growth opportunities that enable a better way to work and live (plus, did we mention we provide a ton of benefits ?). Connecting great people with great companies is what we do best, and our employment opportunities span a wide variety of workstyles, skill levels, and industries around the world.


Kelly is an equal opportunity employer committed to employing a diverse workforce and providing accommodations for people with disabilities in all parts of the hiring process as required under its Employment Accommodation Policy. Kelly will work with applicants to meet accommodation needs that are made known to Kelly in advance.

Categories

Posted: 2022-04-29 Expires: 2022-05-30

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

SQL Server DBA Onsite San Diego, CA

Kelly Services
San Diego, CA 92108

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast