Senior Database Administrator
Tools & Solutions
Total years of experience :7 years, 8 Months
Installation and configuration of MS SQL Server 2016 and SQL Server 2017. Migrated business critical database to cloud. Upgraded non-critical database to latest version. Creating the databases and managing the data and log files. Maintain database security as per business rules and requirements. Configuring and troubleshooting high availability scenarios like Always ON. Working with Database Security things like creating users and providing Db access or restricting privileges. Maintained & Monitored Alert/Schedule to make smooth Server process. Ensure and maintain backup and recovery policies and procedures. Backing up the Database on a daily basis. Creating and managing the Maintenance plans as per the requirement. Resolving blocking processes related issues. Configuring MSSQL Server Alerts in SSRS. Preparing SSRS Reports as requested by client. Working on Various Technologies like Metabase PostgreSQL Server. Troubleshooting in basic Application Server Issues. Upgrading PostgreSQL Server to latest version. Providing table level access for the users in PostgreSQL Server. Trouble shooting issues like slow query running, Statistics update failed, disc space issues. Monitoring PostgreSQL Server. Configuring backups and cross checking backups are able to restore or not by restoring. Configuring HA as Replication like logical replication, cascading Replication and multi slave replications. Configuring various applications like pgadmin, pg_badger. On Call 24/7 Support to databases.
Installation and configuration of MS SQL Server 2016 and SQL Server 2017. Migrated business critical database to cloud. Upgraded non-critical database to latest version. Creating the databases and managing the data and log files. Maintain database security as per business rules and requirements. Configuring and troubleshooting high availability scenarios like Always ON. Working with Database Security things like creating users and providing Db access or restricting privileges. Maintained & Monitored Alert/Schedule to make smooth Server process. Ensure and maintain backup and recovery policies and procedures. Backing up the Database on a daily basis. Creating and managing the Maintenance plans as per the requirement. Resolving blocking processes related issues. Configuring MSSQL Server Alerts in SSRS. Preparing SSRS Reports as requested by client. Working on Various Technologies like Metabase PostgreSQL Server. Troubleshooting in basic Application Server Issues. Upgrading PostgreSQL Server to latest version. Providing table level access for the users in PostgreSQL Server. Trouble shooting issues like slow query running, Statistics update failed, disc space issues. Monitoring PostgreSQL Server. Configuring backups and cross checking backups are able to restore or not by restoring. Configuring HA as Replication like logical replication, cascading Replication and multi slave replications. Configuring various applications like pgadmin, pg_badger. On Call 24/7 Support to databases.
Database Administration, monitoring and troubleshooting all databases daily issues.
Installation and configuration of MS SQL Server 2008R2 And MS SQL Server 2012.
Handling Production, development on different Databases and different environments across 10 SQL Servers Instances.
Creating the databases and managing the data and log files.
Physical Year Database activities.
Production DBA job :-
Monitoring Log file, Temp DB, User login, Blocking Issue, Log Shipping, Mirroring DB, Scheduled Jobs / Task, Error Log, , Disk space, Optimized slow running Report SP, Database Designing / tuning, General Technical trouble shooting and give consultation to Development Team, Activity Monitor and using SQL profiler.
Resolving blocking processes related issues.
Identifying long running & High CPU utilized Queries.
Deploying SSRS Reports through MSBI Tool.
Import/Export the data Text/Excel file and Server to Server.
Migration, Database Engine Tuning Advisor (DTA), Analyzing Indexes and Support of existing T-SQL Store Procedures,
Views and User defined Functions
Maintain database security as per business rules and requirements.
Maintained & Monitored Alert/Schedule to make smooth process.
Interface with other Servers / Databases - Linked Server.
Database Refreshes from Production to Stage and Development environments as per the requirement.
Involved SQL Compare Tool (Compare two SQL Server Databases using Red Gate Compared).
Backup & Restoring of Database on a daily basis.
Monitor Database backups are being performed regularly.
Ensure and maintain sound backup and recovery policies and procedures.
Prepared Production Database Main Table Data Splits Scripts (Based on Client Requirement Backlog date Data moved to another Archive DB. So Current DB size has been reduced).
Involved DB constraints checking and inform to client which is not have Primary keys and Foreign Keys and Fix it.
Create Users and assign permissions based on the level of database access the user would need.
Involved with QA and Development Team.
Database performance monitoring and tuning when required as per application and business requirements.
Conducting monthly Cold Backup Activity and Patches Update.
Checking the Consistency of Databases after Completion of Cold Backup Activity.
Creating and managing the Maintenance plans as per the requirement (Rebuild, Re-org of Indexes of Databases & Updating Statistics Backups ……etc.)
Migrating databases from SQL Server 2008 R2 Enterprise Edition to SQL Server 2012 Enterprise Edition.
Migrating Report Server from SQL Server 2008 R2 Standard Edition to SQL Server 2008R2 Standard Edition.
Managing Application Related Configurations in IIS And Web.config File as Application Developers Requirements.
Configured Always On Availability Group for Financial Year (2017-18 & 2018-19) Wise Databases.
Installation and configuration of MS SQL Server 2005 and 2008R2.
Creating the databases and managing the data and log files.
Maintained & Monitored Alert/Schedule to make smooth replication process.
Ensure and maintain sound backup and recovery policies and procedures.
Database performance monitoring and tuning when required as per application and business requirements.
Backing up the Database on a daily basis.
Creating and managing the Maintenance plans as per the requirement.
Resolving blocking processes related issues.
Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes.
Responsible for refreshing databases as per client request.
Database and Server Decommissions.