PROFESSIONAL SUMMARY

* ***** ** ********** **** SQL Server 2019/2017/2014/2012/2008R2 installation, configuration, migration, and administration

Extensive experience with T-SQL in constructing database objects, triggers, user functions, views, indexes and relational database model.

Expertise in planning and implementing database Security by creating users, roles, and assigning the appropriate permissions

Experience with the implementation and administration of high availability and disaster recovery solutions, including log shipping, database mirroring, clustering, and AlwaysOn.

Extensive experience in monitoring SQL servers using native tools such as, Activity Monitor, SQL Server Profiler, Perfmon, System stored procedures, Dynamic management views.

Experience with database maintenance, management and performance monitoring using third party tools, like Redgate.

Extensive experience in performance tuning/analysis, troubleshooting and query optimization using native tools.

Experience in analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.

Proficient with database backup and recovery models.

Strong knowledge of MS Office products.

Strong ability to work independently and manage one's time.

Strong interpersonal skills, written and verbal communication Strong decision-making, problem-solving skills, critical thinking, and testing skills.

Knowledge of Microsoft ETL tools, SSIS.

Knowledge of Reporting tool, SSRS.

Vast knowledge of using Microsoft SharePoint.

PROFESSIONAL EXPERIENCE

COSTCO

Los Angeles, CA 01/2020 - Present

0

Conducted database refresh tasks from production to lower staged environments, such as development and staging servers.

Provided support for both production and non-production environments.

Responded and resolved all database and performance issues.

Maintain the backup and recovery procedures and policies set in place.

Performed database maintenance tasks.

Assisted in the implementation of log shipping to our non-production servers.

Created database objects such as tables, stored procedures, views.

Maintained and managed the security of the databases.

Applied SQL server patches.

Conducted migration and upgrade of SQL servers.

Implemented and monitored the replication set up on the configured servers.

Managed approximately 300 servers including production and non-production environments such as QA, Test, and Development.

Developed and built strong relationships with the upper management team.

Followed company policies and standards regarding maintaining SQL server instance.

Aided beginner and junior level dba with tasks.

Implemented SQL Server Clustering for AlwaysOn for production instances.

Configured best security practices according to the company’s standards by providing correct permissions through.

Conducted performance tuning/ troubleshooting using various tools such as SQL profiler, DMVs, stored procedures, wait stats, execution plans

Worked in SSIS and SSRS

CVS

Los Angeles, CA 11/2017 – 12/2019

SQL Server Database Administrator

Installed and configure SQL server 2012, 2014, 2016, 2019.

Extensive experience with implementing HADR solutions such as, replications, AlwaysOn, log shipping, database mirroring.

Conducted performance tuning using SQL tools such as profiler, extended events, and database engine tuning advisor.

Supported production and non-production environments.

Performed migration from SQL server versions 2012 to 2014

Assisted in creation of SSIS packages.

Assisted in the generation of reports using SSRS.

Used third party tools such as, Redgate for backups.

Assisted in capacity planning and forecasting.

Daily activities such as providing 100% support to the database and identifying and resolving and job failures, memory allocation, connectivity, slow running queries.

Aided the development team by revising certain queries for better performance.

Assisted in the design and physical layout of the database.

Performed in pre and post configuration of SQL server installation.

Worked on active/active and active/passive clustering.

Designed recovery plans and participated in the recovery plan drills.

Extensive experience with DBCC commands to maintain the integrity of the database.

Forever Living Products International

Scottsdale, Arizona 05/2015 - 09/2017

Junior SQL Server Database Administrator

Involved in analyzing and upgrading SQL Server 2005 test servers to SQL Server 2008.

Experience in the design, development, and deployment of SQL 2008R2 server.

Conducted back up and restore of the database manually and by scheduling the job and maintenance plans.

Moved files between the File Groups and partitioned the tables to improve the performance.

Monitored SQL Server 2008R2 performance using various tools such as, SQL profiler to find performance bottlenecks.

Implemented high availability solutions like Replication models, Snapshot and Transactional, Log shipping, Clustering and Mirroring on physical and virtual machines.

Created database objects and tested their functionalities in lower environments.

Applied patches to pre-production and production environments.

Assisted in migration projects with senior level DBAs.

Responded promptly to any user related tickets.

EDUCATION

Bachelor’s degree

Contact this candidate