Major Tasks, Responsibilities and Key Accountabilities
Partners with Sr. DBA's to create physical database structures for small projects based on physical design for development, test, and production environments.
Performs routine maintenance, including upgrades and patches. Resolves issues via service tickets. Performs daily data back-up and recovery as needed. Generates scheduled and ad hoc reports.
Partners with Sr. DBA's and engineers to configure servers for DBMS product installation and small database creation.
Provides on-call support for assigned databases 24/7 to include investigating and troubleshooting problems.
Configures and maintains DBMS product software on small database and application servers.
Manages conversions of data from legacy/acquired systems as required. Reports escalated issues to Sr. DBA.
Monitors and adjusts database parameters for better performance.
Assists application teams with tuning of SQL statements.
Nature and Scope
Demonstrates skill in data analysis techniques by resolving missing/incomplete information, inconsistencies/anomalies in more complex research/data.
Nature of work requires increasing independence; receives guidance only on unusual complex problems or issues. Work review typically involves periodic review of output by supervisor and/or direct "customers" of the process.
May provide general guidance/direction to or train junior level support personnel or professional personnel.
Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
Typically requires overnight travel less than 10% of the time.
Education and Experience
Preferred Qualifications & Job Specific Details
4+ years of demonstrated experience in Microsoft SQL Server database administration, performance tuning, backup and recovery, high availability, and security
Extensive knowledge of SQL Server versions 2012, 2014, and 2016
Expert in Transact SQL (T-SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)
Experienced in implementing and supporting SQL Server Availability Groups as well as SQL Server Mirroring.
Highly skilled in troubleshooting performance related issues
Job ID 2018-29272