Job Description
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 non-SYS objects Permission on folders, log/trace files to Apps DBA Define and manage user profiles/policies Database Software Maintenance Implement database patches in non-production 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 re-indexing 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 non-production databases by utilizing Customers 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. Skills: mssql,database,rdbms,re-indexing,backup,datafile,postgres,index,sys,statistics,recovery,ms sql,rdbms files,windows server,non-sys objects,undo files,database patches,database software,recovery process,log/trace files,data warehousing,log files,database restore,manage database backup,db account creation,manage user profiles,very large databases,database replication technologies,manage database availability,refresh/cloning/rebuilding of database,tune database parameters,manage database capacity,ensure availability of instance/database,resolve space related errors,troubleshoot database backup issues
Employement Category:
Employement Type: Full time
Industry: IT
Role Category: IT Services & Consulting
Functional Area: Not Applicable
Role/Responsibilies: MSSQL DBA
Keyskills:
database
rdbms
backup
postgres
index
statistics
recovery
ms sql
windows server
data warehousing
mssql
reindexing
datafile
sys
rdbms files
nonsys objects
undo files
database patches
database software
logtrace files
log files
database restore
manage database backup
db account creation
manage user profiles
very large databases
database replication technologies
manage database availability
refreshcloningrebuilding of database
tune database parameters
manage database capacity
ensure availability of instancedatabase
resolve space related errors
troubleshoot database backup issues