Microsoft Certified SQL Server Database Administrator (DBA) with 7+ years of Database Administration and IT experience in various industries such as health care, communication, and IT Consulting Companies. Extensive knowledge in architecting, building and scaling databases for future growth. Experience in managing multiple MS SQL Server with very large OLTP Databases in development, testing/QA and production environments. Excellent team player with abilities to work in independently.
Skills
Auditing, Troubleshoot
Automate, Troubleshooting
Backup, Upgrades
Clustering, Upgrade
Encryption, VM
Clients
Client
Data Management
Data warehouse
Database
Databases
Database design
Disaster recovery planning
Disaster Recovery
DML
Documentation
Erwin
ETL
Features
Functional
Insurance
Microsoft Certified
Windows
Migration
Enterprise
Organizational
Policies
Processes
Reporting
Scheduling
Server configuration
Servers
Scripts
Shipping
MS SQL
MS SQL Server
SQL
SQL Server
Statistics
User Support
Experience
05/2019 to Current
Software Engineer IIIWalmart – Coon Rapids, MN,
Build Windows Server suitable for SQL Server security and performance by partitioning mdf, ldf, backup, temp and audit drives.
Install and configure SQL Server by installing only required features.
Develop, and deploy SPROCs, and other database objects as requested by clients.
Develop, monitor and test database backup processes.
Develop and monitor automate maintenance processes to ensure continued optimal performance of client servers.
Ensure security of SQL Server systems by auditing logins and user accounts permissions, implanting server hardening “Best Practices”, and implementing encryption as requested by clients.
Review server configuration, monitor and optimize query execution, monitor server resource utilization ensure optimal performance of server.
Design, Install and configure clustering for SQL Server instance on SQL 2016 for Always ON implementation.
Responsible for disaster recovery planning for SQL Servers.
Implemented database mirroring for constant availability of insurance and systems.
Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
Responsible for daily operational management and troubleshooting of MS SQL Servers.
Responsible for the design, deployment and control of MS SQL in a virtual VM environment.
Used SQL server management studio and reporting tools to design and manage SQL environments.
Export and Import data from other data sources like flat files using SQL server SSIS.
Ensured that all levels of the migration and deployment processes are going as intended on the SQL Servers.
Work closely with developers to resolve issues.
03/2018 to 05/2019
SQL DBADeloitte – Bethesda, MD,
Supported Data Management in providing technical and support activities related to the administration, maintenance, troubleshooting and support of SQL Servers across the city.
Administered multiple databases and servers across MS SQL Server platforms, including permissions, restoring back-ups, performance tuning and monitoring of scheduled jobs.
Administered SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services across several versions, including permissions, scheduling of reports and maintenance.
Supported Business Analysts in ETL (Extract, Transform, Load) programs/functions/tasks in support of various IS projects.
Created Documentation, management, and updating responsibility for all SQL Server and related processes/systems.
Troubleshoot and resolve database problems as directed/necessary.
Other duties as assigned that support data warehouse, data management, and related needs.
Managed the conceptual and logical data models for the EDW and other Data Marts requiring enterprise information.
Implemented high availability of SQL Server databases.
Upgraded SQL Servers from 2008R2 to 2016 SQL Enterprise Environment.
Performed database reorganization, extent (space management), and rebuilding indexes bases on evaluation of daily database monitoring.
Monitored performance and size of SQL databases to proactively identify and fix potential issues and optimize the configuration.
Created Disaster Recovery plan and testing the plan on a regular basis.
Worked with technical and nontechnical staff to understand user and organizational needs and developed scalable databases to meet functional requirements.
02/2013 to 03/2018
SQL DBADeloitte – Boise, ID,
SQL Server installations, patches and upgrades, including both standalone and clustered environments of production, test and development.
Implemented conceptual, logical and physical database design and maintenance using native tools and third- party tool such as Erwin.
Automated maintenance plan jobs in SQL Server agent and task scheduler: such as shrinking database, database backups, index rebuilding, index reorganizing, clean ups, and updating statistics.
Extensively used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/troubleshooting.
Used third party tools like (IDERA) to maintain, manage, and monitor performance.
Analyzed Locks, Deadlocks using both Spotlight and DMVs and DMFs, and handled the isolation Level and Concurrency Effects.
Implemented and manage transactional log shipping, SQL server Mirroring (Synchronous/ Asynchronous), Failover clustering and transactional replication database objects and perform DML and DDL tasks.
Creating SQL Server Logins and Authentication Modes as a part of Security Policies for various categories of User Support.
Implemented and managed database maintenance and disaster recovery plans including merge and transactional replication.
Performed SQL Server 2008R2 migration to SQL Server 2012, 2014 and 2016 Environments and performed post upgrade configurations.
Designed, Installed and configured clustering for SQL Server instance on SQL2008R2, SQL2012 and SQL 2016 Always ON.
Extensively used PowerShell scripts to gather all necessary information about servers to manage my work load.
Debugged and troubleshoot PowerShell when encountered an error.
Education and Training
Expected in 2017
Certification
Microsoft Certified Solution Associate
: - , GPA:
Expected in 2012
B.S: Information Technology California State University - San Bernardino, CA GPA:
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
