Description
Position: SQL Database Analyst
Location: Columbia, SC
Duration: 12months +
Job Description:
- 20% Define data architecture standards for the organization, structure, attributes, and nomenclature of data elements.
- Design, develop, test, and implement new database objects (tables, views, indexes, databases, etc.) and administer existing architectures supported for performance and maintenance related issues.
- 20% Analyse and recommend best practice steps to prevent potential database issues, such as performance degradation or potential loss of service and well as recommend actions to fix issues when database problems do occur (outages or potential errors). Recommend methods to recover or improve databases to include analysis/review of vendor
- products.
- 15% Provide input into complex decisions as they relate to data architecture, infrastructure and/or administration. Consult with information systems areas on database issues and proposed changes. Recommend tuning to databases and queries when they are not performing to customer requirements.
- 15% Analyse and recommend upgrades to database software and components based on security requirements, new technology, or evolving application system requirements. Analyse and recommend capacity planning (SAN storage) based on captured growth trends and monitoring.
- 15% Review database environments to ensure they meet security controls and audit requirements; continually mitigate identified risks and vulnerabilities. Ensure recoverability of databases by creating, scheduling and monitoring database backups for dependent systems.
- 15% Support management on enterprise wide and departmental goals and objectives. Provide education and information on security policies, practices, and awareness programs. May provide estimation on work efforts and recommendations on training plans for less experience staff.
Daily Responsibilities:
- SQL Server technical resource for SQL-related design, performance, security configuration, troubleshooting and problem resolution for MS SQL Server-related issues in physical and VMware virtualized environments
Technical Background:
- Knowledge of SQL Server and its tools to support a wide range of small and simple to large and complex databases.
- Experience executing SQL Server backups and recoveries with Tivoli Storage Manager (TSM)
- Knowledge and experience with database performance monitoring and tuning
- Experience with database local, windows and Active Directory authentication methods
Note: SQL DBA with TSM experience is mandatory.