SUMMARY

• Microsoft Certified Technology Specialist (SQL Server 2005, Implementation and Maintenance) and Microsoft Certified IT Professional (Database Administrator 2005) with over 15+ year s background in IT / Software development in various areas of database architecture and design. Experience includes database administration, development, schema redesign and data migration for OLTP and OLAP structures in SQL server / Windows and DB2 / Linux environment.
• Expert skills in installation of SQL Failover cluster / AlwaysOn for high availability / disaster recovery.
• Solid SQL - 92 / T-SQL development skills in crafting optimized database objects (ad-hoc queries, views, MQT, UDF and SP).
• In depth noledge in implementing effective and optimized indexes. Thorough understanding of index types such as clustered, non-clustered, covered, include column and index apply strategies in boosting database performance.
• Proficient in data migration utilizing DTS/SSIS as well as tailoring custom scripts for teh single table management with 1+ billion rows.
• Very good understanding of database ACID model, specifically teh isolation level andlock escalation.
• Proficient in choosing teh applicable HADR implementation option (clustering, AlwaysOn mirroring, replication and Log Shipping) as per business RPO / RTO needs.
• Performance tuning experience in identifying slow / resource contention queries / SP.
• Nurtured developers with code review, development tips and tricks sessions in promoting right database design and optimized codes.
• Experience in Software Development Life Cycle (SDLC) in both Agile and Water fall layout.
• Experience in Batch processes, SSAS, SSIS, SSRS, DTS, BCP, Import, Export, and Backup.
• Experience in monitoring teh databases/Server using DMV s, Perfmon, SQLTrace and Activity Monitor.
• Experience with SQL Server Embarcadero Monitoring tools with DBArtisian, Redgate and Idera.
• Proficient in development in Data Studio (primarily, Control Center), TOAD applications for IBM DB2 for LUW 9.7 database management in Linux Environment.
• Solid noledge on Logical & Physical database design, Data Modeling, Conceptual Design and Data Architecture and extensive use of Erwin modeling tool.
• Strong understanding of DW concepts of Star and Snowflake Schema.
• Champion in playing a key role in laying out database implementation, capacity planning and resource allocation.
• Team player in working on 24/7 production support environment.

TECHNICAL SKILLS

Tools: Toad, Embarcadero, ER-Studio, DBArtisian, Redgate, Idera, CA Erwin data modeler, Enterprise Architect, Visual Studio, Perfmon, Visual studio, SnagitIBM Data Studio, VSS, ClearCase, ClearQuest, Connx, MS office

Databases: SQL Server 2000 thru 2012, DB2 LUW 9.7, Oracle 8i/9i and MS Access

Platforms: Windows, Linux, CISAM

Languages: C, C#, XML/XSLT, asp, asp.net, JavaScript, html.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Lead SQL Server DBA

Responsibilities:

• Confidential is a Global technology services provider delivering business solutions and industry s broadest portfolios of information technology, applications and business process outsourcing services for State, County and Local Government.
• Implemented many SQL Server failover cluster (Active/Passive and Active/Active), ALwaysOn, Mirroring, replication, LogShipping for high availability and disaster recovery solutions and for analytical reporting.
• Implemented heterogeneous replication between Oracle and SQL Server.
• 24 /7 production support in proactively monitoring and managing over 300+ SQL Servers 2000/2005/2008/2012 housing over 2500+ databases mission critical database servers.
• Manage day to day activity in keep servers health check from disk space, logs, server errors / IO / CPU/ Memory, applying security, OS and SQL patches.
• Handle high volume daily tickets for SQL troubleshooting, permission, connectivity etc. demanding with quick turnaround.
• Developed various alerts for disk space, failed jobs, permission change etc.
• Actively engaged in multiple (5 - 8 projects) in providing teh right database solutions considering teh RPO/RTO.
• Continuously improving codes for performance and automation, ETL/SSIS data loads.
• Securing Government data by adhering to all checks and balance policy of teh company.

Confidential, Burbank, CA

SQL Server DBA

Responsibilities:

• Proactively monitoring teh database activity and Performance using DMV s, SQL Trace, dashboard and Perfmon.
• Documenting teh changes per client basis and rolling them into teh future upgrades to teh Dev. and production systems.
• Debugging and making changes to teh DB code as needed for teh applications Issues.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in - depth noledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Analyzing Server capacity and configuration for teh application and suggesting teh changes to improve Performance depending on teh user capacity.
• Analyzing and documenting teh hardware needs for teh application based on teh data, usage and teh size of teh organization.
• Maintained and resolved teh issues with teh SQL Server clustered environments.
• Analyzed lock escalation issue and halped resolving blocking and deadlock issues and making schema modification to prevent from occurring in future.
• Involved in teh Installation and upgrades of teh SQL Server along with teh Patch updates.
• Managed several client clustered environments and resolved teh issue with them.
• Mentoring teh Analysts and developers to better assist customers with teh application, SQL issues and to write teh code for better functionality and performance.
• Using PERFMON Counters to analyze hardware and SQL Server resources and changing teh settings to make better use of teh existing resources and evaluating teh resources.
• Data modeling using Erwin for OLTP design depending on requirements to normalize or denormalized structure, usually 3NF, super types and subtypes models. Create subject areas by department.
• Create complex queries using temp table, common table expression, derived tables, and materialized views (indexed views). T-SQL queries, Stored Procedures, User Defined Functions (UDF), utilized Scalar function, Table values function, Cursors, Views and Triggers. Create ad-hoc queries on demand for management and executives.
• Perform ETL utilizing DTS/SSIS package. Manipulate data utilizing pivot/unpivot feature.
• Optimizing and tuning queries by applying cluster, non-cluster and covered indexes where appropriate.
• Manage Index fill factor me.e. keep below 50 for inserts or 70 for read for performance to minimize page splits.
• Led Dev, QA, UAT and Prod in areas of release management for scripts development, deployment, and rollback.
• Manage index fill factor, update statistics for performance.
• Fix orphaned users, troubleshoot connection, create data dictionary, follow and adhere to naming conventions, setup and monitor transactional, snapshot replication, backup, restore, setup alerts for jobs, disk space, setup maintenance task, Monitor w/SQL profiler, perfmon.
• Perform maintenance task for index, statistics, archival / purge tasks, control transaction logs growth.DB2 LUW Application DBA
• Design and implement DB2 database servers for Payroll processing needs.
• Analyze and monitor data processing, database design, and data strategy for transactionaland reporting database systems in order to ensure system workflow within overallenterprise architecture.
• Responsible for managing multiple large DB2 database systems in Production.
• Implement and test data management systems with DB2 databases and data privacy solutions in non-production environments.
• Perform root cause analysis for DB2 database and system related issues.
• Provide on-call support for production DB2 database systems.
• Define and enforce standards, guidelines, and best practices across teh database and data-related disciplines and technologies.
• Manage and administer production database systems, implement new systems and applications for business needs, and lead project initiatives related to DB2 technologies.
• Participate in team code and design reviews.

Environment: SQL Server 2012, SQL Server 2008, SQL Server 2005, Windows 2003 Server, Windows 2008 Server-SQL, Visual Studio for SQL Server, Microsoft Visual Studio 2008

Confidential, Calabasas, CA

SQL Server DBA

Responsibilities:

• Confidential was an industry leader in providing diverse product in home mortgage lending.
• Proactively monitor and manage over 80+ SQL Servers 2000/2005.
• Administered 40+ servers in clustered environment holding financial transactional data
• Setup maintenance plan for administrative task such as re - index, update statistics, reorg, data purge.
• Perform various mass data loading using native SQL DTS/SSIS, BCP and IMPORT/EXPORT utility.
• Setup database mail, configure operators for alerts for failed / success jobs, space notification.
• Exposure to Embarcadero - DBArtisian tool in managing SQL/Windows logins/users account with appropriates right's privileges, applying DB, SP scripts.
• Used Linked servers to access data from SQL Server database to Sybase.
• Setup teh SQL Server Clustering and managed clustered environments.
• Involved in teh Installation and upgrades of teh SQL Server along with teh Patch upgrades.
• Involved in gathering teh requirements related to teh data formatting for Client data feeds, User Reports, System Integration and data warehouse.
• Troubleshooting performance issues and fine-tuning queries and stored procedure.
• Involved in developing teh functions, procedures, Triggers as per teh business requirements.
• Developed complex procedures to handle errors and exceptions at teh database level using T-SQL.
• Implemented Log Shipping, Replication and Mirroring for Reporting purposes and for Disaster Recovery Purposes on various databases.
• Designed teh Maintenance Plans for various kinds of backups and scheduled them as per teh requirement.
• Implemented different Recovery plans in case of database failures and moving teh Databases across teh Environment.
• Monitored teh database during teh testing phase for its activity and Performance using DMV s, SQL Trace and Perfmon.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth noledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Providing 24X7 production support in a nutshell.

Environment: SQL Server 2008, SQL Server 2005, Windows 2003 Server, T-SQL, Visual Studio for SQL Server, Microsoft Visual Studio 2005

Confidential

Jr. SQL Server DBA

Responsibilities:

• me worked with Sr. DBA's in assisting them with every day production support
• Responsible for database backup and restore
• Involved in creating DTS, BCP and IMPORT/EXPORT to provide data for reporting.
• Manage temp db, transaction log growth, me/O volume,
• Implemented snapshot and distribution agents for replication.
• Implemented log shipping to remote site.
• me got some exposure to Oracle 9i Database as well.

Confidential,Simi Valley, CA

System Analyst

Responsibilities:

• me worked in a team to migrate word template into DOC1 application. me actively took part throughout teh SDLC for letter management system; Responsibilities below:
• Setup/Configured and set user access rights in Visual SourceSafe for Doc1 application.
• me worked in Internet application project, got involved in querying AS400 housed on DB2
• Production support with supporting mission critical applications to ensure all jobs are running in a timely manner for two sites
• Handle missing and resubmission jobs.
• Track error jobs in production.
• Development and testing.