SUMMARY

• Over 15 years of experience as a SQL Server DBA in multiple industries.
• Migration of SQL Server and 2016 databases.
• Managing, monitoring and supporting (SSIS) ETL Jobs
• Experience in leading a development team and producing deliverables on time.
• Expertise in SQL DBA Administration, Server Administration and 24x7 Production Support.
• Experience in working in large environments with many number of database instances in Production, Staging, QA & development environments and multiple datacenters.
• Adopt database servers for HIPAA and PCI compliances and work with auditors.
• Design, Architect, Consolidate and Capacity planning for SQL Server Database systems.
• Excellent knowledge in SQL Server 2000/2005/2008/2012 security permissions and best practices
• Extensive experience with T - SQL in constructing triggers, tables, stored procedures, functions, views, indexes, cursors, permissions, and CLR functions.
• Extensively worked on performance tuning and troubleshooting.
• Experienced in MS SQL Database High Availability environments, by using Cluster Failover, Database Mirroring, Log Shipping, and Replication.
• Assisted IT staff with database administration.
• Developed and maintained business continuance strategy of database such as clustering,
• Managed capacity planning of the SQL database to include upgrades to new version of SQL and/or new hardware requirements.
• Responsible for the optimization of all SQL servers via performance tuning.
• Assisted programmers in resolving application specific questions on the MSSQL Server.
• Hands-on experience with Microsoft BI tools including SSIS, SSAS, and SSRS.

Areas of Expertise

• Database Design
• Excellent communication skills
• Data backup and retrieval
• Windows and Linux
• Coding and modularization
• Database queries and indexes
• Excellent diagnostic skills
• High motivated/Self-starter
• Technical specifications creation
• Customer oriented
• Common sense approach to problem solving

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential - Poway, CA

Responsibilities:

• Made recommendations regarding the database platform in terms of design, upgrades, migrations, application performance, operational process, capacity, scalability and recoverability.
• Provided database capacity planning, optimized database queries and indexes.
• Worked on instance and database security by using GUI, T SQL script on login, users group on cluster environment and created a maintenances plan for SQL server.
• Worked with developer team to deploy daily and weekly new build and stories.
• Create few SQL jobs to atomize the monthly deployment to reduce the deployment time.
• Worked with the operation team to install SQL server on Cluster nodes, Migrate legacy Databases to SQL server 2016
• Worked with Info CRM and Scribe environment as an administrator.

Database Administrator

Confidential - Long Beach, CA

Responsibilities:

• Worked on Database migration, by using the import export utility to copy databases and users.
• Schedule database backup and refresh database by restoring and cloning the database on different instance.
• Worked on instance and database security by using GUI, T sql script on login, users group on cluster environment and created a maintenances plan for sql server.

Database Administrator

Confidential, Costa Mesa, CA

Responsibilities:

• Made recommendations regarding the database platform in terms of design, upgrades, migrations, application performance, operational process, capacity, scalability and recoverability.
• Made recommendations regarding the database platform in terms of design, upgrades, migrations, application performance, operational process, capacity, scalability and recoverability.
• Provided database capacity planning, optimized database queries and indexes

Database Administrator

Confidential - Carlsbad, CA

Responsibilities:

• Migrated Oracle tables to SQL server 2008 R2 environments to create reports for developers.
• Utilize SSIS packages and schedule by using SQL agent jobs to run in the off-peak time.
• Worked with the developers to run the reports and email to the clients.

Database Administrator

Confidential - Newport Beach, CA

Responsibilities:

• Established compatibility with third party software products by developing modifications and integration
• Coordinated and executed database upgrades, patches, and installation of supporting utilities.
• Proficient in TSQL. Created and maintained database, stored procedures, triggers and functions.
• Made recommendations regarding the database platform in terms of design, upgrades, migrations, application performance, operational process, capacity, scalability and recoverability.
• Developed reports and fulfilled custom requests for internal end-users by SSRS and Crystal reports.
• Created and ran tabular and matrix reports using SSRS with the help of Report builder and Report designer, including colorful charts and details as per client request.
• Used SSIS to create ETL process to load data in different formats, such as Excel and Text pad.
• Used SSA to schedule reports and housekeeping process including tuning and maintenance.
• Ensured that storage, archiving, back-up and recovery procedures are functioning as planned.
• Used database mirroring to back-up the production database/Worked on Log Shipping and Replication.
• A full concept of Failover cluster, and database recovery in minimal time, without losing any piece of data.
• Ensured network, system and data availability as well as integrity through preventive maintenance and upgrades.
• Trained junior members of IT team regarding network security and trouble shooting of data circuits.
• Provided database capacity planning, optimized database queries and indexes.

Database Administrator

Confidential - Bloomington, CA

Responsibilities:

• Provided corporate wide applications from the IBM mainframe to a client/server environment.
• Deigned, code and converted analysis of data warehouse.
• Enhanced the performance of the company’s Oracle environment by providing an advance performance tuning and coding standard in PL/SQL.
• Installed MS SQL and trained backup DBA’s operation center staff, and other appropriate staff.
• Created tables, wrote procedures in order to schedule date clean up and new rows insertion.
• Maintained MS SQL Server 7.0/2000 for a local client.

Database Administrator

Confidential - Long Beach, CA

Responsibilities:

• Successfully installed Oracle Parallel Server on Unix. Used Sun Cluster and EMC disk management.
• Maintained a high security system and reduced the recovery time.
• Used Erwin for data modeling and reverse engineering.
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts.
• Designed and developed a backup/recovery strategy and procedure for several Oralce9i databases instances.
• Installed Rman database for VERITAS Netback up for backup solution on Production and QA environment.

Database Administrator

Confidential - Long Beach, CA

Responsibilities:

• Installed Oracle on UNIX and created several databases as per clients need.
• Assist developers with database design issues and problem resolution.
• Worked as project and QA lead on several ongoing projects.
• Monitored the database by using Toad and Iwatch (Quest Software)
• Installed and maintained Oracle 8i database remotely (Client in Dallas)

Jr. Database Administrator

Confidential - Wood land Hills, CA

Responsibilities:

• Redesigned a through backup and recovery strategy for all major production system.
• Successfully maintained peak performance of all primary databases by providing advances tuning method and customized scripts.