SUMMARY

• Microsoft Certified SQL DBA with staunch understanding of Administration, Design, Implementation & Support with expertise in Performance Monitoring and Tuning, Query Optimization, database consistency checks, Deadlocking and Blocking analysis and remediation, management of MS SQL Server databases, including database capacity planning, database users and roles creation and monitoring, ensuring SQL Server High Availability Alternatives, Database Mirroring, Log Shipping, and Server Replication.
• A proven leader, who is a dedicated, self - directed individual with strong communication and organizational skills and an ability to work independently and function as an integral part of the team, exercising good judgment, prioritize multiple tasks in fluid work environment

TECHNICAL SKILLS

Databases: Microsoft SQL Server MS-Access, MS Excel and Lotus Notes

Languages: C#, HTML, PL/SQL and T-SQL

Operating S: Microsoft SQL Servers 00/03/05/2008/ 2008 R2/ 2012 and 2012 R2

Tools: SSMS, Enterprise Manager, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, DB Artesian, N Central, Data Transformation Services (DTS), SQL Diag, Bulk Insert and BCP, VMware, SSIS, SSRS, Lit speed, SQL Trace Analyzer, SQL Deadlock detector, MS Access, SQLite, Visual Studio, OLAP Services, Active Directory, Change Management, DB Pro, Fog light, Spotlight, Light speed, Performance Analysis Tool, TFS - Team Foundation Server and DBSmart

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

SQL Server DBA

Responsibilities:

• Administered and managed Microsoft SQL server databases, including installation, upgrades, configuration, backup / recovery, patching of new and existing RDBMS, performance monitoring tuning, troubleshooting problems and expansion.
• Managed deployment of SQL Server service packs, hotfixes and cumulative updates throughout the production and non-production environments, in accordance with regular and scheduled maintenance windows
• Managed, configured, and troubleshoot High Availability solutions for SQL Databases through SQL Clustering, Database Mirroring, Transactional Replication, and AlwaysOn
• Monitored alerts and escalations and resolved issues within an agreed time scale.
• Performed code migration across multiple environments using TFS - Team Foundation Server
• Performed capacity planning, database tuning, and performance monitoring to ensure operational stability and availability of all databases
• Managed job scheduling application for database and system tasks
• Coordinated with Engineering, Development, DBAs, QA, offshore and Operation teams on daily basis
• Provided on-call, off-hour, production-problem resolution, as well as scheduled deployments support

Confidential, Irvine, CA

SQL Server DBA

Responsibilities:

• Administered and Managed MS SQL databases ensuring high availability and performance of the databases, proactively monitored the database systems to ensuring minimum downtime by overseeing backup, clustering, mirroring, replication and failover, and performed capacity planning and monitoring database growth
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping
• Supported Auditing of all production SQL Servers, and to keep DB servers in compliant with audit requirements
• Created database improvements and maintenance plans for monitoring database integrity and performance
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans
• Provided continuous monitoring, troubleshooting, historical, real time performance monitoring of SQL Server environments
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
• Resolved problem/incident tickets based on their priority, working with end users to get them resolved as quickly as possible
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
• Provided ON-Call Production support on a weekly alternate schedule for 24/7

Confidential, Orange, CA

SQL Server DBA

Responsibilities:

• Performed administration, deployment and operational support of production, development and test environments utilizing proper change management and other best practices
• Collaborated with product managers, application architects, business analysts and technical management team to design, develop and document databases, schemas, tables, functions, triggers, procedures, relationships and other necessary aspects of the database
• Performed planning, analysis, design, implementation, maintenance, control of the organization's server-class databases
• Provided information by collecting, analyzing, and summarizing database performance and trends.
• Resolved database performance issues, capacity issues, replication and other distributed data issues.
• Managed Production, QA and Development Database Environments
• Configured, managed, monitored, maintained and troubles hooted all SQL Servers
• Configured and maintained database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Implemented, maintained and improved database backup, disaster recovery and high-availability solutions
• Developed SSIS packages to extract, transform and load data from multiple input sources like flat files, excel with multiple sheets, Production SQL Servers into SQL Server 2008R2/2012 Staging Database.
• Created Ad hoc Reports, Drill down Reports, and Matrix Reports in SSRS
• Worked outside of normal business hours, e.g. nights and weekends, as needed for on-call support, software release/deployment, systems upgrades, patches, and troubleshooting

Confidential

SQL Server DBA

Responsibilities:

• Administered MS SQL server databases including installation, upgrade and managing SQL Server 2005/2008/R2/2012 databases servers in production and non-production environments
• Performed database backup/recovery, replication, rebuilding and reorganizing indexes including troubleshooting and resolving issues with database integrity, performance, blocking/deadlocking, connectivity, and data replication issues etc
• Implemented data synchronization between development, test, and production platforms
• Ensured the availability and high performance of all production and non-production SQL Server instances.
• Monitored and optimized the performance of the database
• Provided database support for critical business applications that execute 24x7x365
• Monitored and fixed any database backup failures
• Proactively monitored databases both from a performance and capacity management - disk utilization stats perspective
• Maintained an ongoing configuration design and documentation for the databases

Confidential

SQL Server DBA

Responsibilities:

• Planned, analyzed, designed, implemented, maintained, and controlled the organization's databases.
• Planned, Organized and Co-ordinated testing phases of migration during the Wells-Fargo and Wachovia merger process
• Liaised between the management, my team, development team, users and the BAs to facilitate the merging activities
• Collaborated with other IT teams including IT Security to ensure that databases and data are secure, reliable and accurate
• Implemented, Optimized, data performance, database security, Performance Tuning, Indexing, Query Optimization
• Monitored and managed SQL Server Agent Jobs to ensure successful completion.
• Implemented the disaster recovery process, database backups and implementation of security policies.
• Performed troubleshooting of database log shipping, mirroring, replication and clustering problems
• Worked with third party tools Quest Lite Speed for log shipping and Fog light for performance monitoring.
• Managed database security and user permission and privileges in accordance with application and database requirements.
• Provided 24x7 on-call support and maintenance predominantly to the production databases.
• Configured Log shipping to create standby environment; Implemented Snapshot and Transactional Replication.
• Evaluated Server Performance Bottlenecks by analyzing the memory usage, CPU Processor utilization, Disk reads/writes, user connections and locks.
• Extracted large volumes of data from different data sources and loaded data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Migrated Databases from SQL Server 2000 to SQL Server 2005 and 2008 in Development and Test Environments.
• Configured database mail, created operators, jobs, and alerts for automating databases.
• Created Database Backup Plans for Full, Differential and Transactional Database Backups.
• Resolved Deadlock & Blocking Lock Issues by setting Trace Flags like T1204 and T1205