Database Administrator

SUMMARY Essential Duties and Responsibilities include the following. Other duties and tasks may be assigned.

• Creates and maintains production, reports and development databases
• Performs proactive capacity planning to ensure database availability is not affected
• Performs proactive monitoring and performance tuning of the database instances
• Install various patches to keep databases up to date and install new versions of the Oracle / SQL Server database to ensure compatibility with existing applications
• Plans and implements backup and recovery of the databases.
• Good experience to manage and implement encryption (SSL & TDE).
• Experience to migrate Non-CDB database to CDB database.
• Implements and enforces security for all of the Databases(Oracle / SQL Server).
• Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the various database objects design and code to ensure the site standards are being adhered to.
• Evaluates releases of Oracle / SQL Server and its tools, and third party products to ensure that the site is running the products that are most appropriate.
• Planning is performed by the DBA to ensure that application release takes place with minimal impact.
• Provides technical assistance from database perspective to application development teams in designing various objects in the database schema.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures, as well as Database Replication.
• Assists with impact analysis of any changes made to the database objects.
• Troubleshoots problems regarding the databases, applications and development tools.
• Configures and maintains Cross Database Replication tools(Eg. Oracle Golden Gate Services) to ensure reports databases stays in sync
• Setup new users and privileges as required
• The DBA has ultimate responsibility for the physical database design.