Description
SQL Server DBA -10 month contract, Charlotte, NCSummary The DBA team is responsible for the design, build, ongoing maintenance, failure avoidance, detection and repair of the SQL Server databases associated with the applications. The SQL Server DBA team is also responsible for control of the Production/QA Web and Application Server environments from an application change control perspective including installations, problem analysis with the Application Support team members, evaluating vendor recommendations, standards and procedures. '
Responsibilities: Implementation and support of Microsoft SQL Server Database Systems, Reporting Services, Analysis Services and Integration Services on enterprise and dedicated Windows Servers to support Duke Energy applications Design, install, tune, maintain and monitor SQL Server databases, products and services; including, but not limited to, storage management, DB performance tuning, DB software debugging, backup and recovery, and change/configuration maintenance
- Install and maintain Microsoft IIS web server directories and application software systems
- Assist Application-support teams in troubleshooting .NET web applications issues.
- Install and maintain Tomcat web server applications.
- Ability to understand and execute vendor software system installations including troubleshooting issues that arise during installations
- Ability to diagnosis server issues affecting the running of an installed software system.
Basic Qualifications
6-9 years experience in the design, implementation, and support of SQL Server databases. Experience with technology features in SQL Server such as Partitioning, File Groups, Replication, Materialized Views, and Options available in executing database statistics Significant experience with installing and configuring new SQL Server releases, management of database tables - sizing, expansion, and protection Strong SQL Server database performance analysis and tuning skills including tracing and profiling. Experience in installation, administration and debugging of applications/systems on Microsoft Windows application Servers
Desired Qualifications
- Working knowledge of SSIS for Extract, Transform and Load for Operational Data Stores and Data Warehouses Experience with NetApp/IBM SAN storage as infrastructure components to support deployment of SQL Server databases Experience with designing and delivering SQL Server databases in support of major applications. Experience with tools utilized in the design and support of SQL Server databases, such as SQL Server Management Studio, MSX, Erwin Data Modeler Experience with BMC Remedy Change Management/Incident Management software
- Experience with development of server-based web-enabled software applications in Microsoft .NET
- Experience in installing and maintaining Tomcat web server-based applications