SUMMARY:

• More than 9 years of experience in server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning of MS SQL Server Database in production, development environment and as sales representative.
• Worked on a full phase of SDLC from Designing, Creating, Developing, Implementation and Rollouts from Development environment to QA to UAT and finally in Production.
• Experience in MS SQL Server performance tuning, client/server connectivity, troubleshooting, clustering, query optimization, and maintaining, supporting, monitoring production and test environments.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server using Import/Export utility, BCP & SSIS Packages.
• Experience in working with reporting tools such SQL Server Reporting services (SSRS).
• Experience in working with OLTP systems as well as reporting and historical OLAP environment on data ware housing projects.
• Proven ability to implement database administration policies that optimize performance while ensuring database integrity and security.
• Experience in implementing SQL Server Security and object permission like creation of users, configuring permissions database authentication modes and assigning roles of users.
• Expertise in implementing High Availability and disaster recovery mechanisms like replication models, log shipping, database mirroring, Always On and clustering.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries.
• Experience with performance tuning, query optimization, managing indexes and tables.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, UNIX

RDBMS: SQL Server, Oracle, MySQL, DB2

Database Tools: Profiler, DTS, Management Studio, Enterprise Manager, Query Analyzer, BIDS, SSIS, Always On, Clustering, Mirroring, Log Shipping

Web Technologies: XML, HTML, JAVA Script

Cloud: Amazon AWS, Microsoft Azure

Languages: T - SQL, C, JAVA

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Applications: Microsoft Office, Erwin, MS VISIO

Networking: TCP/IP, Named Pipes, VIA

PROFESSIONAL EXPERIENCE:

Confidential, WA

SQL Server DBA

Responsibilities:

• Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
• Administrated and Managed SQL Server 2016 & 2014 databases in Production, Stage, UAT, Test and development environments.
• Administrated 135+ servers and worked on large databases ranging from 5 to 8 TB.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Planed phased implementation of security patches in coordination with application team to minimize downtime to end users.
• Involved in database processes and ETL processes from database and server standpoint, worked with developer teams to develop and implement the database changes.
• Created SQL Server Logins and assigned Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Worked upon Back up and restoring the data base manually and by scheduling the jobs and Maintenance Plans.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for ETL application.
• Developed Reports from OLTP and OLAP server using SSRS and presented them in different forms using graphs, charts, tabular, area and pie charts.
• Responsible for creating & managing schema objects like Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Requirements Using T- SQL.
• Involved in troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Configured Transactional Replication and Log Shipping with SSMS as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Extensively worked on 24x7 Production Database on Call Support and involved in troubleshooting SQL Server issues in various levels.

Confidential, RI

SQL Server DBA

Responsibilities:

• Served as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space management.
• Interfaced with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems.
• Designed and implemented backup plans as per the data- retention policy outlined in the Business Requirement Document.
• Supported Load Testing activity by setting up and scheduling Performance Monitor (Data Collector Sets) and SQL Server Profiler Trace and monitoring them during the activity.
• Responsible for Performance Monitor and used SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Responsible for data migration from Excel, to MS SQL as well as Extracting, Transforming and Loading of data using SSIS.
• Worked on replication for synchronization of databases for SQL Server High Availability.
• Created Logins and Users as per client's policy and requirements and assigned roles as needed according to the project plan.
• Implementing Utility Control Point (UCP) for monitoring CPU Utilization and Disk space utilization in Database Servers.
• Provided 24x7 production support for SQL Server databases on Clustered Servers to achieve maximum performance and uptime in production environment.
• Created and managed databases, schema objects such as tables, views, indexes, procedures, triggers and database constraints to meet business requirements and policies and maintained referential integrity.
• Set up SQL Server configuration settings to resolve various resource allocation & memory issues for databases and setup ideal memory, min/max server options.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Involved in migrating the current Windows environment to AWS environment and worked on Script language using AWS Command Line Interface (CLI).
• Set up backup and recovery plans, also had a proper documentation platform making sure data is secured at all levels.

Confidential, CA

SQL DBA

Responsibilities:

• Involved to work with troubleshooting the stored procedures, functions, views, triggers and part to be increasing the performance tuning.
• Administrated and Managed SQL Server 2014/2012 databases in Production, QA and development environments.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Implemented Always on Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs and building platform with the using of SSIS to feed in BIDS and SSAS cubes.
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks and versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.

Confidential, Phoenix, AZ

Sales Representatives

Responsibilities:

• Check-in with store decision maker, check-in delivery, obtain signatures, collect proof of delivery. Using equipment (e.g. carts, pallets, etc.) to unload products and move throughout the store.
• Merchandising cases from the back room to the sales floor, filling display units or shelves with products such as Doritos, Classic Lays, Tostitos, Cheetos, etc.
• Ensuring back-room inventory reaches the sales floor and organizing/maintaining back-room inventory in proper location.
• Rotating products and removing defective and out-of-date products and process returns and credits with receiver,
• Tidying up shelves and displays, knocking down boxes and disposing of any waste. Safely maximizing sales and minimizing waste.
• Assembling and disassembling of promotional materials such as signs, banners, and cardboard displays. Ordering, scanning and logging back stock using handheld device.