SUMMARY

• Over 7 years compound IT experience in various industries, including Banking, software consulting & services, marketing, high technology, network design/modeling and maintenance, telecommunication.
• Solid 6 years in depth experience in MS SQL Server database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, optimization, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Proficient with SQL Enterprise Manager, Query Analyzer, Management Studio, Business Intelligence development studio, rescheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. OLAP, OLTP, data warehouse design, trouble shooting.
• Experience in Transparent Data Encryption to encrypt an entire database for Security and Backup encryption using SQL Server 2008/2008 R2.
• Experience with software development life cycle (SDLC) and project management methodologies. Plus, proficient with third party SQL tools: Lite speed, Idera, SQL Compare, Redgate, Net backup.
• Strong experience with Data modeling and Database Logical and Physical Design. Excellent problem-solving, troubleshooting skills. VLDB handling experience, over 1TB.
• Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements
• Develop and implement policies and standards for preserving the integrity and security of data
• Hands on experience about SQL 2005/2008 installation/configuration/migration crossing different editions. DTS/SSIS design for SQL/DB2/Oracle/Access DB/Excel/text file.
• Solid experience as MS SQL Server DBA with excellent T-SQL coding and testing: UDF, views, triggers, cursors, stored procedures, etc.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, log shipping, disaster recovery.
• Efficient response to database events in a production environment including resource management, performance monitoring of cluster administration, managing high-availability, scaling VLDB, database recovery, distributed partitioned database design, replication, DTS/SSIS, log shipping and mirroring.
• Developed T-SQL stored procedures/functions to process the data and populate them in the appropriate destination tables
• Experience with data modeling, logical and physical database design using Erwin.
• Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs
• Experience with hardware/software consulting &service. Network logical/physical design/modeling and maintenance. In depth knowledge of TCP/IP network configurations, planning, implementation and optimization.
• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005/2008/2008r2 on windows 2003/2008 Servers.
• Documenting all the server and database related information
• Experience in writing and debugging Stored Procedures and Triggers.
• Troubleshooting issues occurred during Migration.
• Monitoring and Troubleshooting jobs in Production, Stage and Development environment.
• Excellent skills in Information System planning, development and implementation.
• Provided 24h/7d production on call service.

TECHNICAL SKILLS:

Platform: Windows NT 4.0 Server, Windows server 2000/2003/2008 Enterprise/Standard, Windows XP, Windows 2000

Data warehousing/BI: MS SQL OLAP / Analysis and DTS Services.

Web Technologies: HTML, DHTML, XML, XSLT

Databases: SQL server 2000/2005/2008.

Internet/Web: IIS4.0/5.0/6.0, MS Exchange Server, Microsoft SharePoint server

Programming: SQL, T-SQL, ASP, VB, HTML, XML.

Desktop Application: MS Office Suite, Dreamweaver, IE, Netscape Navigator/Communicator, Norton Utilities, Anti-Virus

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

SQL Server DBA

Responsibilities:

• Involved in Providing Complete Database and Application Support which includes Server Upgrades, Build out’s and Migration of Servers by Setting-up Product across Servers.
• Performance tuning operations like Load balancing, Archiving, Indexing, Query optimization, performance monitoring.
• Monitored multiple client databases for effectiveness of queries, SQL Agent jobs, database engine performance and troubleshooting failed procedures.
• Modified existing SSIS ETL packages for code reuse.
• Daily Tickets and other Deployment/New Application Rollout’s and Change Requests.
• Controlling day to day activities of Production database and troubleshooting the issues.
• Index Defragmentation by Rebuild/Reorganize of Indexes on a monthly basis across all Databases.
• Providing technical helpdesk support & assistance for online Production issues 24X7
• Co-coordinating with Team Members & supporting the clients for product implementation & daily support activities.
• Involved in working with Disaster recovery, backup and restore scenarios along with DBCC data integrity checks, statistics updating and reorganization or rebuilding of indexing.
• Responsible for Installation, Upgrade, Design, and Implementation of SQL Server 2005 to 2008 Enterprise database environment for multiple client’s sites.
• Created a mirrored database on the report server using Database Mirroring with High Performance Mode
• Configured, Monitored and Trouble-shooted DB mirroring Replication, Log shipping
• Set up, oversee, and trouble shoot network architecture, server side configuration, client side configuration, connection, and Server level and database level security.
• Responsible for more than 150 SQL Server instances and 250 databases
• Resolved database performance issues (IO saturation, disk bottleneck, network bottleneck, etc…), database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor.
• SME for Replication issues & existing publications & subscriptions to keep data in synch & solved a 5 year old problem with Snapshot Replication.
• Performed database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.
• Created and implemented best backup, recovery strategies (Full Backup Model with 1-hour period transaction logs backup.) and re-indexing process for the Commerce Online banking servers.
• Performed day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
• Collaborate with developers, network administrators, system administrators to implement secure, reliable database environments
• Worked with developers to tune the SQL queries using SQL Profiler.
• Experience in Installing and Configuring Failover Clustering for high availability in Active/Passive or Active/Active and also combined clustering and database mirroring
• Designed and implemented Disaster Recovery sites using Mirroring and Log Shipping
• Developed and assisted in Analysis services cubes, stored procedures, user defined functions, indexes and indexed views.

Environment: Windows server 2008. SQL server 2005/2000, .Net Win 2003/2008 Server, IIS 5.0/6.0, Clustering, SSIS.

Confidential, Irvin, CA

MS SQL Server DBA

Responsibilities:

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Implementing Data Integrity (Domain, Entity and Referential) by means of Constraints, Rules, Defaults and Triggers. Schedule regular Database Maintenance tasks like re-indexing, maintaining the Fill-Factor for the indexes, updating the statistics, remove Fragmentation for DB.
• Scheduling Full and Differential Database backups, and Log Backups to disks, tapes or remote servers, using batch scripts, T-SQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.
• Support multiple SQL Server 2000 / 2005 databases in both clustered and non-clustered environments with replication/DTS. Troubleshoot issues within a clustered server configuration. Installed and configured Report Server on windows 2008 server.
• Monitoring and troubleshooting SQL Agent Jobs including backup and batch job.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Responsible for developing and deploying reports using SQL Server Reporting Services(SSRS)
• Created summarized reports using Reporting Designer
• Improve query execution times by reducing stored procedure recompilations, making use of auto-parameterization, using sp executesql, created Covered Indexes using Server-Side Cursors to reduce the network roundtrips between Client and Server.
• Setup Transactional and Merge Replication between Servers, and troubleshoot and monitor Publishers, Distributors, and Subscribers.
• Involved in designing and configuring a replication server where production database was replicated into two different databases: Read-only reporting database and disaster recovery database.
• Designed, developed and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues; Setup Replication between sites. Used Query Tuning & Diagramming to encourage Developers how to design their applications to ensure the Query Optimizer uses the best plan, and improve congruence.

Environment: SQL Server 2005/2008, Windows 2003, MS Access 2008, Log Shipping, Clustering, Mirroring, SSRS, Web Services, Transact-SQL, JavaScript, SSIS, MS-Excel, Database Backups.

Confidential, Cleveland, OH

SQL Server DBA

Responsibilities:

• Maintained 105 SQL Server servers which are in dedicated and shared environments.
• Configured and troubleshooting replication, log shipping, mirroring, clustering and database maintenance jobs.
• Handling backup process, writing the automated jobs for taking the weekly full backup, daily differential backups and hourly transactional backups.
• Created and maintained the knowledge base system for all the application databases.
• Experience in using high availability features logshipping, mirroring and replication. Granted permissions to end users according to their level of access to database objects.
• Performed Query tuning and used fragmentation strategies to avoid contention.
• Created/altered databases, table extents, indexes, constraints as necessary.
• Mentored developers and supervised their work for accuracy and improvement.
• Interacted with database and application issues of users daily.
• Isolated large tables into their own table space for quick restore purposes.
• Monitored disk space utilization and added or freed extents accordingly.
• Regular SQL Server Maintenance Activities

Environment: Win 2000/2003, SQL Server 2000/2005

Confidential, Rochester, OH

SQL Server DBA

Responsibilities:

• Checked the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Gathered business requirement for creating the new mission-critical databases from customers and internal employees.
• Performed installations of database server and client, service packs and security patches.
• Monitored SQL Server performance using Windows monitor on CPU, network, physical drive, memory, etc. and monitored query performance and batch performance using SQL profiler, DBCC tools. Analyzed, identified and provided solutions for bottlenecks
• Experience in performance tuning of long running queries and stored procedures by using SQL Profiler, Performance monitor.
• Created database maintenance plans and jobs to update statistics, defrag indexes, and check integrity.
• Optimized database design with proper normalization, index setup and with efficient T-SQL / SP queries.
• Established and implemented appropriate database security plans to include maintaining logins, user accounts and ensuring proper levels of user access.
• Understood SQL Server storage structures and index architecture. Monitored server configurations, database capacity and growth.
• Analyzed storage, CPU, memory and network capacity needs, designed a strategy for data archiving, established database conventions and standards for new production database servers.
• Provided data migration solutions to ensure integrity.

Environment: MS SQL Server 2000 Enterprise Edition (4-way, 32 bits), Windows 2000/2003 server.

Confidential

Junior SQL Server DBA/Developer

Responsibilities:

• Estimating and configuring MS SQL Server 2000 Enterprise Edition for development, Maintained 50 SQL Server servers which are in dedicated and shared environments
• Configured and troubleshooting replication, log shipping, mirroring, clustering and database maintenance jobs
• Handling backup process, writing the automated jobs for taking the weekly full backup, daily differential backups and hourly transactional backups.
• Regular SQL Server Maintenance Activities Index rebuild and update statistics, Database Backup, Data Imports and Exports.
• SSIS Jobs, Reporting Jobs through SQLCMD, Archiving, and Gather Database counters.
• On call support.
• Created and maintained the knowledge base system for all the application databases
• Provided guidance to the development team on writing stored procedures and implemented the standards, guidelines and best practices for database development
• Involved in using SQL profiler, Query analyzer for monitoring SQL databases.
• Involved in creating triggers and cursors to maintain database an audit trail of all records in the database.

Environment: Win 2000/2003, SQL Server 2000/2005.