Cloud)

TEKsystems•Winston-Salem, NC

1d•$50 - $55•Hybrid

About The Position

Reports to the IT infrastructure Manager, this position is focused on ensuring that all areas of Database operation function smoothly. This position includes rotational weekend support and after/before standard office hours to ensure department coverage (7am/7pm).

Requirements

Database administrator
Sql
Windows
Oracle
Sql server
Cloud
Systems engineering
sql query
Bachelors’ degree or equivalent
7-10 years in similar role
Strong written and spoken communication skills.
In depth knowledge on Oracle and SQL servers.
Strong knowledge on Database Cloud solution.

Nice To Haves

Azure cloud solution will be an asset.

Responsibilities

To provide support of Oracle/ SQL server/Cloud DB(Snowflake/Azure) management technology and its deployment/usage standards.
To support and maintain SQL scripts for Store Procedure and Database maintenance tasks.
To assist BI and development team database design, and SQL script creation/tuning.
To ensure that all Database environmental changes are appropriately tested and implemented in such a manner that there is no impact to integrated systems and clients.
To provide and maintain all Database documentation
Maintain Disaster Recovery Plan.
Maintain new and existing user profiles.
Maintain SOX Security Documentation.
Setup and configure all new Database.
Maintain, install, and upgrade Database patches.
Provide client services resolving issues and enhancement requests as they arise.
Performance tuning and troubleshoot database system including index/memory/cpu/space analyzing.
Highly skills and experience on Database CDC, cluster and replications.
Document all procedures in the operations folders. Include screen prints where applicable. Ensure that when a procedure changes that the documentation is updated in a reasonable fashion.
Organize and maintain software license inventories.
Enforce physical and network security policy.
Assist in maintenance and client setup of remote Database access connections.
Research projects as requested by the Infrastructure manager of IT.
Make recommendations, based on research and solution comparison for new technology acquisitions and enhancements.
Assist in the effective communication of upcoming planned and unplanned systems changes to users.
This position includes rotational and on call support to ensure departmental coverage outside of normal business hours including weekends.
Can also be broken down into areas if the role requires it as follows