IT Database Specialist

Job Description

Job Description

Position : IT Database Specialist

Department : Information Technology

Job Summary : Maintenance, configuration and implementation of the databases. This includes, backup, storage, access and partitioning of databases. Ensures efficient installations, configurations, troubleshooting, and maintenance of database systems. Monitor and optimize current database systems to ensure quality system performance, by utilizing index tuning, disk optimization, and various other methods that are appropriate. Confirms permissions and privileges within the system to define who can access and control what information ensuring safety and security of the databases to maintain the confidentiality of data.

Duties and Responsibilities (specific areas of responsibility include but are not limited to) :

• Clustering and breaking apart SQL Databases
• Manage installation and configuration of SQL Server database, standalone and cluster platforms.
• Provide database server configuration and server requirements
• Create, enhance and coordinate migrations of database schema implementations
• Design, create, and test database backups and recovery strategies as required
• Manage database projects for SQL Server platform upgrades and patches
• Develop strategic goals for production of databases
• Supports database performance by monitoring database performance; evaluating and resolving processing problems; designing database management tools; managing and maintaining database maintenance schedules
• Secures database(s) by preparing access and control, policies and procedures; implementing disaster recovery procedures.
• Design and build databases from determining business requirements.
• Perform data mining in SQL, Oracle , DB2 and , mySQL databases
• Manage data exporting and importing across database
• Prepare database reports for managers as needed.
• Performs other job-related duties as assigned.

Knowledge, Skills, and Abilities :

Mandatory Requirements :

Preferred Requirements :