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 knowledge 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 the single table management with 1+ billion rows.
• Very good understanding of database ACID model, specifically the isolation level and lock escalation.
• Proficient in choosing the 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 the 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 knowledge 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.

EXPERTISE:

• SQL Server
• SQL DBA
• SQL Developer
• SQL 2005
• SQL 2008
• SQL 2012
• SQL 2014
• SSIS:
• SSRS:
• T-SQL:
• PTO:
• Data Modeling
• SSAS:
• Disaster Recovery:

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:

• 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 the right database solutions considering the 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 the company.

Confidential, Burbank, CA

SQL Server DBA

Responsibilities:

• Proactively monitoring the database activity and Performance using DMV s, SQL Trace, dashboard and Perfmon.
• Documenting the changes per client basis and rolling them into the future upgrades to the Dev. and production systems.
• Debugging and making changes to the DB code as needed for the applications Issues.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in - depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.
• Analyzing Server capacity and configuration for the application and suggesting the changes to improve Performance depending on the user capacity.
• Analyzing and documenting the hardware needs for the application based on the data, usage and the size of the organization.
• Maintained and resolved the issues with the SQL Server clustered environments.
• Analyzed lock escalation issue and helped resolving blocking and deadlock issues and making schema modification to prevent from occurring in future.
• Involved in the Installation and upgrades of the SQL Server along with the Patch updates.
• Managed several client clustered environments and resolved the issue with them.
• Mentoring the Analysts and developers to better assist customers with the application, SQL issues and to write the code for better functionality and performance.
• Using PERFMON Counters to analyze hardware and SQL Server resources and changing the settings to make better use of the existing resources and evaluating the 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 i.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

Confidential

Responsibilities:

• Design and implement DB2 database servers for Payroll processing needs.
• Analyze and monitor data processing, database design, and data strategy for transactional and reporting database systems in order to ensure system workflow within overall enterprise 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 the 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:

• 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 the SQL Server Clustering and managed clustered environments.
• Involved in the Installation and upgrades of the SQL Server along with the Patch upgrades.
• Involved in gathering the requirements related to the 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 the functions, procedures, Triggers as per the business requirements.
• Developed complex procedures to handle errors and exceptions at the database level using T-SQL.
• Implemented Log Shipping, Replication and Mirroring for Reporting purposes and for Disaster Recovery Purposes on various databases.
• Designed the Maintenance Plans for various kinds of backups and scheduled them as per the requirement.
• Implemented different Recovery plans in case of database failures and moving the Databases across the Environment.
• Monitored the database during the 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 knowledge 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:

• I 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, I/O volume Implemented snapshot and distribution agents for replication.
• Implemented log shipping to remote site.
• I got some exposure to Oracle 9i Database as well.

Confidential, Simi Valley, CA

Programmer analyst

Responsibilities:

• I created this web page using classic ASP. The objective was for employees to rate their supervisor for the given questionnaires.
• I worked in a team of three to fine tune this application
• Confidential is a workflow application.

Confidential, Simi Valley, CA

System Analyst

Responsibilities:

• Setup/Configured and set user access rights in Visual SourceSafe for Doc1 application.
• I 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.