Previous Job
SQL server DBA
Ref No.: 18-67567
Location: SAN Diego, California
Position Type:Contract
Experience Level: 8 Years
Start Date: 09/14/2018
∑        Confirm development\pre-production database servers are backed up and meeting engineering recovery needs. 
∑        Keep Confluence and Database Documents up to date the all TCM environments. 
∑        Deploy database changes to development\pre-production\production database environments. 
∑        Identify and troubleshoot resource intensive operations on SQL Server. 
∑        Collaborate with engineering, developers, SMEs and others, provide suggestions on how to improve database design on database objects. 
∑        Review all SQL scripts, stored procedures, functions, etc.  And make sure SQL coding standards used by other developers. 
∑        Performs complex bug verification, release testing and beta support for assigned products, researching problems discovered by QA or product support. 
∑        Ability to translate TCM business needs into technical solutions for application and reporting requirements and identify the data sources to fulfill any given requirements and provide level of effort estimates 
∑        Ability to communicate effectively both verbally and in writing 
∑        Create and maintain SSIS, replication, and SQL Agent jobs and other database processes. 
∑        Microsoft SQL Server Administration skills for SQL 2008 R2, 2012, 2014, 2016, and 2017
Education / Experience:
∑        A completed college degree is preferred. 
∑        Experience with the Microsoft SQL Server software stack - SQL Server databases, SQL Server Integration Services, and SQL Server Reporting Services. 
∑        3 + years of related experience at a professional level.
Qualifications and requirements:
∑        Strong communication skills 
∑        Develops solutions to the problems. 
∑        Ability to determine root cause of given database problem and offer solutions to minimize future application impact 
∑        Experience with scalability, slow query optimization 
∑        Review, evaluate, design, implement, and maintain the database environments 
∑        Eagerness to work collaboratively with a the engineering team in an agile-scrum process
Experience installing, administering, and maintaining SQL Server:
∑        Expertise in crafting a performance tuning of complex SQL Server database objects. 
∑        On-call troubleshooting experience for SQL Server. 
∑        Ability to perform database maintenance tasks such as performance-tuning, partitioning, backups, indexing, job maintenance, and SQL Server version upgrades. 
∑        Experience with Reporting Services, and/or Integration Services.
∑        Familiarity with troubleshooting application and database logic. 
∑        Knowledge of Entity Framework is a plus. 
∑        Prior experience with IOT or Telecom is a plus.