LiveCareer-Resume

sql server database administrator resume example with 13+ years of experience

Jessica Claire
  • Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
  • :
Professional Summary

Talented Database Administrator with 12+ years of diverse experience in database design and administration, data modeling, data warehousing. Extensive technical skills and advanced understanding of SQL Server,Oracle and Postgres administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving.

Skills
  • Multiple Databases (SQL server, Oracle & Postgres)
  • Relational Database Management
  • Systems administration
  • Communications
  • MS Office
  • Implementing security measures
  • Running backups
  • Problem Resolution
Work History
SQL Server Database Administrator, 12/2017 - Current
Genesis Consulting Group New Carrollton, MD,

Client Name : Farmers Insurance Group

Duration : Nov 2017 to Till Date

Location : Woodland Hills , CA

Client Name : United States Automobile Association

Duration : Feb 2017 to Nov 2017

Location : San Antonio, Texas

Responsibilities in SQL server:
• Worked on SQL Server 2016 & 2012 migration from SQL Server 2008 / 2005 (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.

Responsibilities in Oracle:
• 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

Responsibilities in Postgres:
• 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

SQL Server Database Administrator, 06/2013 - 02/2017
Genesis Consulting Group Fort Worth, TX,

Client Name : United States Automobile Association.

Duration : Jun 2013 to Feb 2017

Responsibilities:
• Worked on SQL Server 2016 & 2012 migration from SQL Server 2008 / 2005 (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

SQL Server Database Administrator, 05/2011 - 06/2013
Genesis Consulting Group Boise, ID,

Client Name : Travelers (An insurance Company)

Duration : May 2011 to June 2013

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

SQL Server Database Administrator, 04/2007 - 05/2011
Genesis Consulting Group Columbia, MD,

Client Name : Microsoft

Duration : June 2007 to Dec 2009

Client Name : NIKE

Duration : Jan 2010 to Oct 2010

Client Name : NESTLE

Duration : Nov 2010 to May 2011

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

• Table refresh between two servers using DTS

• Adding and removing the IIS servers whenever needed,
• 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

• Monitoring SQL machines and IIS machines using Sitescope tool

• Checking the SQL replication between EBIS DB and metropolis DB

• Checking all the terminal servers and doing DELPROF if the users are facing any issues,

Education
Bachelor of Science: Computer Application, Expected in 04/2006
-
Bharathidasan University - Tiruchirappalli, TamilNadu,INDIA,
GPA:
Status -
Certifications

• Microsoft Certified Technology Specialist (MCTS) in SQL Server 2005
• Certified in Hardware and Networking – IIHT (Indian Institute of Hardware Technology)
• ITIL Foundation in IT Service Management

,

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Bharathidasan University

Job Titles Held:

  • SQL Server Database Administrator
  • SQL Server Database Administrator
  • SQL Server Database Administrator
  • SQL Server Database Administrator

Degrees

  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: