MSSQL DBA

MS SQL L3 Position

Experience with very large databases and/or data warehousing.

Good knowledge of MsSQL on Windows Server

Some experience on Postgres SQL is preferred.

The role requires below responsibilities

Database user account management:

DB account creation

Grant access rights on SYS and nonSYS objects

Permission on folders log/trace files to Apps DBA

Define and manage user profiles/policies

Database Software maintenance:

Implement database patches in nonproduction and production environment; execute test plan and rollback if necessary.

Database Monitoring:

Monitor database log files for errors.

Monitor database components affecting connectivity e.g. listeners process and log.

Monitor database backups

Monitor database related OS/network parameters

Monitor free space availability on the database server

Manage Database Capacity:

Monitor growth rate of database objects and proactively resolve space related errors.

Monitor RDBMS log files and archive them in a timely fashion

Monitor mount points to keep free space available on which RDBMS files and database files are located.

Relocate physical database objects for example datafile index UNDO files as necessary to manage space on the server.

Manage Database Availability:

Ensure availability of instance/database listeners log files space of log files and other RDBMS related processes.

Database Maintenance:

Perform reindexing as necessary to improve database performance.

Generate statistics as needed for improved program

Tune database parameters to improved performance

Manage Database Backup and Recovery:

Plan and execute backup and recovery process for production and nonproduction databases by utilizing Customer s backup infrastructure.

Troubleshoot database backup issues

Perform database restore from backup as requested by Customer

Database High Availability management:

Provide support for database replication technologies.

Perform refresh/cloning/rebuilding of database

Create new database/instance;

Database software installation:

Estimate size and create directory structure on the server for RDBMS installation

Install and configure database software

Job Location: Any

Timings: 24*7

Exp (Relevant): 8 Years.

re-indexing,very large databases,database,windows server,datafile,high availability management,refresh/cloning/rebuilding of database,database user account management,troubleshoot database backup issues,mssql,database restore,postgres sql,manage user profiles,database capacity management,log/trace files,database backup and recovery,database software,database monitoring,db account creation,backup,recovery process,manage database backup,database software installation,postgres,recovery,statistics,index,manage database availability,ms sql,rdbms,database patches,rdbms files,non-sys objects,database software maintenance,database availability management,database replication technologies,sys,undo files,ensure availability of instance/database,resolve space related errors,manage database capacity,database maintenance,data warehousing,tune database parameters,log files