We provide IT Staff Augmentation Services!

Sql Server Operations Support/ Database Administration Resume

Woodland Hills, CaliforniA

PROFESSIONAL PROFILE:

  • Seasoned IT professional with comprehensive Technical skill set in SQL Server DBA production support.
  • Proficient problem - solver who envisions business and technical perspective to develop workable solutions.
  • Experienced in handling Production issues and providing efficient solutions.
  • Excellent database support record demonstrating excellent customer service, ability to troubleshoot and ability to innovate and customize.

AREAS OF EXPERTISE:

  • SQL Server Database Migrations / Upgradations
  • Proficient SQL Server DBA with excellent understanding of database concepts like T-SQL, Backups, Log Shipping, Replication, Mirroring, Always-On, Clustering (Windows, Veritas)
  • Worked in Client Side (Microsoft).
  • Hands-On experience in Oracle and PostgreSQL databases
  • Hands on experience in SQL Server DBA production support, WLBS Cluster
  • Power shell scripting and SQL Queries

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Hills, California

SQL Server Operations support/ Database Administration

Technologies used: SQL Server 2005, 2008, 2012, 2014 and 2016, Oracle, PostgreSQL

Responsibilities:

  • Worked on SQL Server 2016 & 2012 migration from SQL Server (using Backup/Restore, Detach/Attach and Drive/Mount point mirroring)
  • Worked on SQL server Import/Export for moving the data from higher version to lower version
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
  • Expertise in designing databases and capacity planning.
  • Implemented Merge Replication for CISCO databases
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
  • Handling database space issues
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Having hands on experience in DR processes including Log shipping and Database Mirroring.
  • Troubleshoot performance problems
  • Implemented Always-ON (AAG) on SQL Server 2016 SP1 (4 Node Configuration)
  • Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 (2 Node Configuration)
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Logging into the server and setting the environment
  • Creating Users and granting them access
  • Creating schemas and Roles
  • Created DB link as per the users request
  • Performing Import/Export on the schema level as per the users request
  • Executing scripts as on the Oracle databases and spooling the output of the scripts
  • Looking for active sessions and checking if any queries are running longer
  • Checking the database status in RAC using SRVCTL commands
  • Checking the TableSpace details and increasing the space if required
  • Installing Postgres on the Linux server
  • Creating database and connecting to the database
  • Creating users and granting them the required access
  • Creating the tables as per the application requirements
  • Taking backup and restoring the database using PGADMIN tool
  • Stopping and starting the Postgres instance
  • Creating schema’s and creating tables on the schema
  • Executing the scripts on the Postgres database using PGADMIN tool

Confidential, San Antonio, Texas

SQL Server Operations support

Technologies used: SQL Server 2005, 2008, 2012 and 2016

Responsibilities:

  • Worked on SQL Server 2016 & 2012 migration from SQL Server (using Backup/Restore, Detach/Attach and Drive/Mount point mirroring)
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
  • Expertise in designing databases and capacity planning.
  • Created SILENT install scripts for installing SQL server 2012 and 2016 without any manual interruption
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
  • Handling database space issues
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Having hands on experience in DR processes including Log shipping and Database Mirroring.
  • Troubleshoot performance problems
  • Implemented Always-ON (AAG) on SQL Server 2016 SP1 (4 Node Configuration)
  • Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5 (2 Node Configuration)
  • Strong experience in mentoring team members and writing documentation.
  • Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Experience in using SQL Server Profiler, SQL Server Agent

Confidential

SQL Server Operations support

Technologies used: SQL Server 2000, 2005, 2008.

Responsibilities:

  • Troubleshooting of backup failure
  • Doing master rebuilt
  • Creating RCA’s
  • Migration of the Databases from lower version to Higher versions
  • Creating Logins and granting access to the users
  • Handling T-log space issue
  • Working with clustering and standalone SQL servers
  • Failover in Clustering
  • Restoration of DB’s from PROD to Pre-PROD, DEV, etc…
  • Creating Logins and providing the access
  • Installing SQL server 2005, 2008
  • Creating secondary data and log files in case of space issues both in standalone and Clusters
  • Table refresh between instances using IMPORT and EXPORT
  • Creating databases
  • Doing table level restore
  • Install / Upgrade the SQL server on production servers
  • Troubleshooting space issue
  • Creating and scheduling the change

Confidential

SQL Server Operations support

Technologies used: SQL Server 2000, 2005

Responsibilities:

  • Troubleshooting of backup failure
  • Migration of the Databases from lower version to Higher versions
  • Creating Logins and granting access to the users
  • Handling T-log space issue
  • Working with clustering, mirroring, Replication and Database Mirroring
  • Failover in Clustering
  • Restoration of DB’s from PROD to Pre-PROD, DEV, etc…
  • Creating Logins and providing the access
  • Installing SQL server 2005
  • Creating secondary data and log files in case of space issues both in standalone and Clusters
  • Creating maintenance plans and scheduling the jobs
  • Configuring Replication, adding an article in Publications, Troubleshooting Transactional Replication issues
  • Table refresh between instances using IMPORT and EXPORT
  • Creating databases
  • Install / Upgrade the SQL server on production servers
  • Troubleshooting space issue
  • Moving the system DB’s to another location (Master, Model, MSDB and Tempdb)
  • Taking backups of the Encryption Key
  • Executing the scripts on user’s request
  • Patching SQL server

Confidential

SQL Server Operations support

Technologies used: SQL Server 2000, 2005 & 2008

Responsibilities:

  • Migration of the Databases from lower version to Higher versions
  • Creating Logins and granting access to the users
  • Handling T-log space issue
  • Working with clustering, mirroring, Replication and log shipping environment
  • Table refresh between two servers using DTS
  • Database refresh (using Backup, restore and Detach, attach)
  • Creating Logins and providing the access
  • Installing SQL server
  • Creating maintenance plans and scheduling the jobs
  • Creating databases
  • Install / Upgrade the SQL server on production servers
  • Troubleshooting space issue
  • Recreating the Index
  • Moving the system DB’s to another location (Master, Model, MSDB and Tempdb)
  • Taking backups of the Encryption Key

Confidential

Production Support

Technologies used: SQL Server 2005, Windows.

Responsibilities:

  • Working as Primary DBA for production database, Solving On calls Issues and Supporting PG (Product Group) Team
  • Monitoring, rerunning the backups and trouble shooting in case of failures
  • Adding or removing the servers in DPM backups as per the customer’s request.
  • Upgrading the DPM agent in all the servers (ie.., Master servers as well as the client servers) across all the regions
  • Reducing the manual efforts by writing SQL Queries.
  • Creating and using the power shell scripts to pull the backup details for the protected servers and their resources.
  • Checking the connectivity issues between master servers and protected servers.

Hire Now