SQL DBA

SUMMARY:
A SQL DBA will be responsible for the provision of day-to-day database administration and support in a large corporation with a multiple database environment, including resolution of database problems, data backup and restore, and the production of database performance statistics. Includes the installation, configuration, upgrade, administration, and monitoring of databases and associated software products, in support of operational systems and the development environment. Ensures data integrity across multiple databases and ensures consistent data structure, data recovery, maintenance, data integrity, and space requirements for physical database are met through implementation of policies, procedures, and standards relating to database management. Able to interrogate databases using an appropriate programming / query language.

POSITION INFO:
Responsibilities:
Functional Support
- Oversee the maintenance, configuration, and implementation of everything that has to do with databases.
- Respond to and resolve database access and performance issues.
- Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
- Monitor, optimize and allocate physical data storage for database systems.
- Plan and coordinate data migrations between systems.
- Perform database transaction and security audits.
- Establish appropriate end-user database access control levels.
- Develop routines for end-users to facilitate best practices database use.
- Provide solution to any complex IT related challenges in the organization
Enterprise Tasks
- Benchmark, analyse and test new technologies.
- SQL flavour requirements, upgrades and downgrades (Enterprise through to Express).
- Data and/or server migrations.
- High Availability assessments and best-fit application (AOHA and Failover).
- SQL patching and Rollup installations and planning.
Facilitate enterprise integrations with SXi and other vendors
- Evaluate new software releases and products.
- Ensure regular updates, plan future rollouts.
Customer experience
- Customer SLA’s are key
Data Maintenance
- Data Warehousing setup and capacity planning.
- Backup and recovery strategies (PIT and PID).
- Database hardware requirements (Capacity Planning).
Reporting & Continuous Improvement
- Develop, implement, and maintain change control and testing processes for modifications to databases.
- Create, or support creation of, required reports in response to business user needs.
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
- Keep up with trends in the constantly evolving information technology industry.
- Perform regular IT audit to discover areas of weaknesses and fortify them.
Administration and Knowledge
- High Availability health checks and regular failover tests.
- DMV maintenance
- Outdated index updates and tuning of existing.
- SQL performance monitoring (General, Locks, Buffer) managers.
- Review error mails from all integration packages and fix code bugs and/or improvements (SSIS and custom code written).
- Ensure SSAS packages executed the previous night.
- Review error mails on replication errors and spot check a few instances.
- Keep QA and DEV databases up-to-date with PROD for testing.
- Ensure IIS on web servers are running and is responsive.
- Deploy new/existing code and patches to running software (C++/C#).
- Storage management (Log and log files that needs shrinking).
Verify SQL backups to disk.
- Design, architect, and build databases from determining business requirements.
- Write and troubleshoot complex stored procedures.
- Develop innovation, strategies, processes, and best practices.
Manage Human Resources
- Manage and mentor team members.
- Work closely with programming staff on database design changes to meet business requirements.
- Review completed tasks to ascertain compliance with standards.