SQL Server DBA
Resume:
Himanshu Jani
****.********.*@*****.***
Phone: 408-***-****
___________________________________________________________________________________________________________________________
SUMMARY
• More than 15 years of IT experience with around 10+ years in Business Intelligence (BI) space.
• Understanding of leading technologies in BI and Strong Data Analysis & Architect skills.
• Extensive Performance tuning experience on both OLTP and Data warehousing environments.
• Evaluated, planned and implemented database upgrades and designed new database systems.
• Implemented performance tuning measures to measure and quickly react to performance issues to meet or exceed SLA.
• Strong communication and provided 24X7 production database support. Recognized as a creative and effective troubleshooter and problem solver.
• Managed offshore resources and projects in different countries.
EXPERIENCE
Senior Database Architect 12/2008 – Current
El Camino Hospital, Mountain View, CA
• Lead and Implemented Microsoft Amalga Unified Intelligence System project.
Microsoft Amalga offers a new way to capture, store and present information, enabling health systems to unlock data sitting in clinical, financial and administrative silos across organizations. Amalga helps provide clinicians, administrators, financial managers, and researchers with instant access to the data they need, when they need it. Without replacing any current systems, Amalga helps bring together patient data from hundreds of different sources. Amalga turns data into role-based information and health critical knowledge.
• Has managed and executed all phases of a Business Intelligence project life cycle during the tenure that includes Scoping Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance, Application Support for end-to-end IT solution offerings in Datawarehousing, OLAP & BI space.
• Designed and created real time & ETL process to integrate data from different unrelated data sources.
• Translated logical design into one or more physical Databases, and designed how the Data will flow through the successive Stages.
• Designed and performed data migration that includes Validation, Clean-up and Mapping, and created data dictionaries.
• Lead the project including data quality and testing.
• Designed and Created Dashboard using various BI tools.
• Completed Data Quality concepts such as Master Data Management, Data Governance and Data Stewardship.
• Translated business needs into long-term information architecture solution.
• Lead Business Intelligence Team and mentor architects, technical team and software engineers in BI-related architectural issues and best practices.
Senior Database Architect 10/2005 – 12/2008
Accenture, San Francisco, CA
• Created, Configured and Maintained 9i and 10g VLDB Oracle databases.
• Managed various projects and worked as a Tech Lead.
o Managed Oracle 9i and 10g Database upgrade and conversion project.
o Managed Data warehouse re-engineering project.
o Managed Database Standards project.
• Automated DBA tasks
o Log file purging, runaway process detection and cleanup
o Object and SQL pinning, scripting to manage the shared pool
o Shutdown and startup scripting for all application components
o Index rebuilds
o Idled forms session termination, lock detection and cleanup
o Monitoring and alert notification of key 11.X components
• Performance tuning expertise includes
o Oracle Supplied Utilities like collection of statistics using STATSPACK/AWR
o Tune application design in terms of optimizer behavior, execution plans and indexing strategies
o Measure and improve performance of the shared pool and database buffer cache
o Set optimal size for SGA areas like Large Pool, Java Pool and Shared server processes
o Partition management (Creation, deletion and maintenance)
o Managed Materialized Views, starting from user requirements, definition and maintenance
o Optimize sort operations
o Tune the appropriate resources to minimize latch contention
o Use Oracle blocks efficiently (High water mark, recover space from sparsely populated segments)
o SQL statement tuning (TRACE, EXPLAIN PLANS)
o Monitor and detect lock contention
o Reconfigure and monitor rollback segments
o Created scripts to analyze tables and indexes to keep the application performing as desired.
• Backup Solutions: Created several customized scripts to perform different modes of backup and recovery.
• Purged temp and unwanted data in different modules to reduce overall size of database making it easy for ongoing maintenance and cloning of data.
• Worked on re-engineering data warehouse and provided performance tuning of data warehouse operation.
• Advised developers on the use of appropriate hints (FIRST_ROWS is for fast response, etc) and on the use of bulk updates, bulk inserts to speed application performance
• RDBMS and application patching
o Stay with the highest certified level of the RDBMS and research/log any abnormal database error with Oracle support
o Automated/ expedited/non-intrusive patch applications (adpatch, adadmin, admrgpch)
Senior Database Administrator 07/2000 – 10/2005
Silicon Graphics Inc (Sgi), Mountain View, CA
• Created, Configured and Maintained 8i, 9i and 10g Oracle, MS SQL Server and Sybase databases.
• Planned and implemented upgrade of Oracle 11.5.9 application.
• Coordinated with Business teams and Oracle to resolve application and database issues during requirements, user acceptance testing cycles and go-live phase through TAR’s. (Oracle Technical Assistance Requests)
• Understanding of Oracle Application 11i Tech stack including configuration of HTTP server, Jserver, Concurrent Manager, Jinitiator and Oracle’s multi-tier architecture.
• Managed SOX project worked as a team lead.
• Setup Oracle 10g HA solutions including ASM, RAC, Standby servers, Data Guard.
• Plan, Implement and test disaster recovery system, using RMAN.
• Provided 24x7 production supports for Oracle, Sybase and MS SQL Server databases and ERP application.
• Designed logical and physical Data Models using ERWIN forward-engineered into DDL to create database.
Consultant – Senior Database Administrator 02/2000- 07/2000
Sybase Corporation, CA
• Database design, installation, upgrades and maintenance of Sybase ASE versions 11.0.3, 11.5.1 (raw partitions and file systems)
• Replicated data across servers using Sybase Replication server 11.5.1
Consultant – Database Administrator 02/1999- 11/1999
Mississippi Public Service Commission (MPSC) , MS
• Implemented effective backup and recovery procedures to provide 24x7 hours Oracle database availability to end user.
• Provided 24x7 hours production database support.
Database Administrator/Programmer Analyst 08/1994- 11/1998
EMCO -Elecon, India
• Provided 24x7 Oracle database support.
• Performed database administration and Performance tuning activities on Oracle Databases.
• Implemented effective backup and recovery procedures.
• Interact with end users to understand user requirements. Design, developed and implemented the Finance System.
HARDWARE AND SOFTWARE
• Databases – Oracle 7.2 – 9i,10/11g, MS SQL Server 2000,2005&2008, Sybase 11.0.3 – 12.5.0
• OS – Sun-Solaris, HP-UX, IBM-AIX, Linux, DOS, Windows
• Programming Languages – PL/SQL, SQL*Plus, Shell scripting, Perl, C, C++, CGI, HTML
• Software applications – QlikView, Data Protector, Open View, Erwin, Toad, Quest Spotlight, DBA Artisan
EDUCATION
1994 M.S Computer Science, India
1990 B. S. Statistics, India
Contact this candidate