Sudheer Kumar Mikkilineni                 

Summary:

·         9+ Years of total IT experience in Software Systems Design & Development, responsible for data design, Database administration and data modeling in various domains.

·         9 years as Oracle Database Administrator (Proficient in Database Administration Activities).

·         8+ years of experience Oracle Database Administrator in OLAP and OLTP Databases.

·         7+ years of experience in Shell Scripting and Perl Scripting.

·         Expertise in Installation, configuration, creation, upgrades and migrating Oracle environments (8i/9i/10g/11g) on HP UNIX, AIX, Sun Solaris, Linux and Windows XP/NT servers.

·         Hands on experience in database backup and Recovery strategies using RMAN, Cold/Hot backups to tape with vendor software’s like VERITAS, Netapp, BMC sql backtrack and EMC TimeFinder.

·         Oracle Data guard and Standby databases experience.

·         Hands on experience of Oracle Real Application Clusters (RAC), Oracle Cluster Ready Service (CRS) and Automatic Storage Management (ASM).

·         Experience as On-Call/pager 24x7 Production DBA support, Development DBA and System Administrator.

·         Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments like RUP, Agile and DB change Management.

·         Strong knowledge on oracle Internal Views, Data-Dictionary and Oracle Utilities.

·         Configuration of Oracle Enterprise Manager (OEM) and Grid controller for monitoring, performance enhancement and debugging.

·         Building ad-hoc queries/ complex SQL queries Report development.

·         Experience in Developing ER Diagrams using design documents using Erwin.

·         Experience in troubleshoot/monitor script, creation of log files, packages, procedures and functions. Develop scripts for DTS for transferring data using SQL*Loader, Export/Import. Involved In writing PL/SQL Scripts for Parsing of HL7 Messages.

·         Monitoring and optimizing the Performance of the database, turning Management, Change Management, capacity planning, create new technologies and SQL tuning.

·         True team player; maintain client/customer relationships by providing timely, superior quality products and services, understanding of client/customer needs and satisfaction criteria.

·         Working experience with Very-Large databases (VLDB) up to 10 terabytes, data migration to Oracle from other databases such as MS Access, Sybase and SQL Server.

·         Maintained numerous Oracle development, test database instances and provided 2nd and 3rd level Production support as well.

·         Practical solutions to problem solving with creative ideas, identify patterns, linkages and underlying situations, consider customer needs in evaluation of solution.

·         Prepare Project Plan and maintain the work schedules for Tracking and managing the project offshore and onsite teams.

SKILLS

CERTIFICATIONS

Oracle Certified Associate (OCA)

Clearances

In addition to these skills, I currently hold a High-Level Clearance with the US Department of Veterans Affairs.

EXPERIENCE

Client: Publix Super Markets, FL                                                                                  08/09 to Till Date

Role: Lead Oracle DBA

Publix Super Markets are one of the largest in super markets chain in South East US. Publix Has more than 1200 stores spread across the Florida, Georgia and Alabama States.

Responsibilities:

• Involved in data modeling and data architecting for Supply Chain and Pharmacy Schemas.
• Designed and implemented various high availability solutions in Oracle9i, Oracle10g using Data Guard, RMAN, Oracle Real Application Clusters (RAC) and Oracle Flashback.
• Migration of large terabyte size databases from 9i to 10g on Solaris 10, 10g to 11g On AIX.
• Involved in partitioning of very large tables using list and range partitioning.
• Installed Oracle Clusterware CRS, Clustered Install of Oracle 10g, applying opatch in clustered environments, created database / instances using DBCA on a four node cluster, troubleshooting RAC at OS / OCR / CRS / DB Level.
• Keep track of resource utilization and make sure that effective utilization of the resources.
• Adding Security at Schema and Database level according to SOX and HIPAA Rules and securing Listeners.
• Continuously audits and reports on all security and usage activity of all databases and at user level.
• Responsible for tuning of RMAN Backup using netbackup and tuning SAN and VERITAS I/O System.
• Setup and supported for Oracle 10g/11g High Availability (HA) solutions including ASM, Grid Controller and Data Guard.
• Generating data movement code, compiles code, execute the code and troubleshoot data movement problems.
• Atomized Proactive Monitoring works using Shell/Batch (DOS) Scripts and extensively documents all changes to the production database including time-logs.
• Setting up Flash Recovery Area in Automatic Storage Management for backup strategy.
• Used Grid Controller to monitor and schedule RMAN scripts to manage records of the backup and validated backups to ensure that the database can be recovered when necessary.
• Performed Database and SQL tuning by using various Tools like StatsPack, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Created scripts and Database deployment Instructions for migration of DB Objects and Data Fixes to facilitate the Production Migration.
• Resolved performance issues with poorly performing queries and Locks. Used few tools such as Sql Tracing, and Stats pack as part of the troubleshooting.
• Daily data refreshes from production into different environments and every day builds.
• Challenges on coordinating with off shore team and driving few projects successfully till the end.

Environment:

Solaris/HP-UX/Linux/AIX/Zlinux, Oracle 8i/9i/10g/11g, RAC, Data Guard, Grid Controller, ASM, Streams, Informatica, ADDM, AWR, ASM and VERITAS.

Database Size: over 10TB

Client: Veterans Health Administration (VHA), Federal Govt., UT                                     01/08 to 06/09

Role: Lead Oracle DBA/Data Architect

The Health Data Repository (HDR) System project is responsible to provide national centralized database for all VA hospitals. HDR Project provides is step for their standardization of database from old mumps database.

Responsibilities:

• Involved in data modeling and data architecting for HDR (Health Data Repositories).
• Created Business Model, Logical Model & Physical model using Erwin from UML documents.
• Migration of large terabyte size databases from 9i to 10g on Solaris 10.
• Responsible for RAC support for production, development and test environments.
• Keep track of resource utilization and make sure that effective utilization of the resources.
• Adding Security at Schema and Database level according to HIPAA Rules and securing Listeners.
• Responsible for tuning of server parameters, network workload and disk IO etc.
• Detail-oriented and minimum risk-taker and performance parameters are well tested in development test and then in QC databases before bringing it in production.
• Setup and supported for Oracle 10g HA solutions including ASM, Grid Controller and Data Guard.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager) and Grid Controller.
• Atomized Proactive Monitoring works using Shell/Batch (DOS) Scripts and extensively documents all changes to the production database including time-logs.
• Setting up Flash Recovery Area in Automatic Storage Management for backup strategy.
• Involved in partitioning of very large tables using list and range partitioning.
• Proficient in implementing and handling issues with Backup and Recovery strategies for Oracle databases. Data pump, Online and Offline Backup, RMAN & disaster recovery procedures.
• Responsible for Performance tuning of complex SQL Queries pertaining to various stored procedures, Triggers etc.
• Extensive use of Enterprise Manager Tuning & Diagnostic Packs, Explain Plan, Sql Trace/TKProf was made to achieve this scalable.
• Created scripts and Database deployment Instructions for migration of DB Objects and Data Fixes to facilitate the Production Migration.
• Resolved performance issues with poorly performing queries and Locks. Used few tools such as Sql Tracing, and Stats pack as part of the troubleshooting.
• Guiding and providing all the information needed to improve performance to the developers.
• Responsible for creation of new Data models and updating based on changing requirements.
• Daily data refreshes from production into different environments and every day builds.
• More challenging Adhoc issues related to several databases and few on UNIX area.
• Continuously audits and reports on all security and usage activity of all databases and at user level.
• Implemented Parsing of HL7 Messages.
• Challenges on coordinating with off shore team and driving few projects successfully till the end.

Environment:

Solaris/HP UNIX, Oracle 9.2.0.2/10.2/11.1, Toad, Stats pack, ERWIN, Informatica, ADDM, AWR, ASM and VERITAS

Database Size: over 5TB

Client: Cavalry Portfolio Services LLC, Phoenix, AZ                                                            01/06 to 12/07

Role: Senior Oracle DBA/ Data Architect

Cavalry Investments, LLC is a privately held firm which purchases different national consumer receivable portfolios (Accounts). The Accounts that are purchased by Cavalry Investments are referred to Cavalry Portfolio Services for servicing. The CCS is an Intranet based Application which has several modules. Cavalry Portfolios Services starts from collection of portfolios from Cavalry Investments.

Responsibilities:

• Involved in data modeling and data architecting for Cavalry Collection System (CCS).
• Created Business Model, Logical Model & Physical model from documents using Erwin.
• Migration of Oracle 9i Databases to 10g on Solaris 10.
• Responsible for RAC support for production, development and test environments.
• Keep track of resource utilization and make sure that effective utilization of the resources.
• Adding Security at Schema and Database level and securing Listeners.
• Responsible for tuning of server parameters, network workload and disk IO etc.
• Detail-oriented and minimum risk-taker and performance parameters are well tested in development test and then in QC databases before bringing it in production.
• Setup and supported for Oracle 9i/10g HA solutions including ASM, Grid Controller and Data Guard.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager) and Grid Controller.
• Automized Proactive Monitoring works using Shell/Batch (DOS) Scripts and extensively documents all changes to the production database including time-logs.
• Setting up Flash Recovery Area in Automatic Storage Management for backup strategy.
• Involved in partitioning of very large tables using list and range partitioning.
• Used Grid Controller to monitor and schedule RMAN scripts to manage records of the backup and validated backups to ensure that the database can be recovered when necessary.
• Responsible for Performance tuning of complex SQL Queries pertaining to various stored procedures, Triggers etc.
• Extensive use of Enterprise Manager Tuning & Diagnostic Packs, Explain Plan, Sql Trace/TKprof was made to achieve this scalable.
• Created scripts and Database deployment Instructions for migration of DB Objects and Data Fixes to facilitate the Production Migration.
• Resolved performance issues with poorly performing queries and Locks. Used few tools such as Sql Tracing, and Stats pack as part of the troubleshooting.
• Developed mappings from sql server to oracle using Informatica.
• Guiding and providing all the information needed to improve performance to the developers.
• Responsible for creation of new Data models and updating based on changing requirements.
• Daily data refreshes from production into different environments and every day builds.
• More challenging Adhoc issues related to several databases and few on UNIX area.
• Continuously audits and reports on all security and usage activity of all databases and at user level.
• Automated different processes in various areas to reduce the manual intervention.
• Challenges on coordinating with off shore team and driving few projects successfully till the end.
• Working knowledge of TCL scripting to automate the OWB process.

Environment:

Solaris/HP UNIX/AIX, Oracle 9.2.0.2/10.2, Toad, Stats pack, ERWIN, Informatica, COGNOS, ADDM, AWR, ASM and VERITAS

Database Size: over 2TB

Client: LPL Financial, CA                                                                                               01/04 – 12/05

Role: Sr. Oracle DBA

LPL Financial is a Financial Based company. LPL was formed in 1989 through the merger of two small but successful brokerage firms, Linsco (established in 1968) and Private Ledger (founded in 1973). Today, LPL is America's No. 1 independent brokerage firm with more than 6,500 financial advisors based in more than 4,000 branch offices nationwide.

Responsibilities:

• Setup and supported for Oracle 9i/10g HA solutions including Standby servers on AIX.
• Supporting Testing, Development and Production environments on more than 30 UNIX servers.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Stats pack, and V$ dynamic views.
• Setup, Configured Oracle Data Guard using physical standby database.
• Upgrading of Oracle 8i Databases to 9i and 10g.
• Created, maintained, and monitored the Standby Database.
• Performance tuning of several mission critical OLTP databases supporting java applications. Employed various Oracle 10g Features/tools such as Automatic Database Diagnostics Monitor (ADDM), Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning, AWR and Automatic Segment Space Management (ASSM).
• Involved in partitioning of very large tables using list and range partitioning.
• Responsible for creation of new Data models and updating the existing Data models based on changing requirements.
• Adding Security at Schema and Database level and securing Listeners.
• Provided Oracle version 9.2.0.4 Replication Support for Development of new security software. Analyzed replication environment, provided replication support fixes and provided Oracle Patch installation.
• Performed Large Terabyte size Database Backup including Physical backup through Hot Backup/Cold Backup of Oracle Database on Raw Devices using compress with Shell/Perl Scripts and Logical backup using multiple streams Export / Import on UNIX.
• Designed and developed scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc
• Meet the SLA on each database by maintaining high availability / uptime
• Involve in the Capacity Planning for databases based the future business growth requirements
• Provide On-Call support to production Databases on rotation basis.
• Designed and developed Daily Schema Change Monitoring program across all Databases

Environment:

Sun Solaris/AIX/Windows, Oracle 8.1.7.4/9.2.0.2/10.2, Toad, Java, JSP, Stats pack, VERITAS, ADDM, AWR, ASMM, ASSM.

Database Size: over 1TB

Client: True Dial Technologies Inc., FL                                                                                      08/02 – 01/04

Role: Oracle DBA

True Dialer is a system that automatically dials the telephone for your telemarketers connecting only live voice contacts to them every 6 - 8 seconds. The way our system does this is by 'listening' and filtering out the answering machines, busy signals, operator intercepts, and other types of non-functional calls.

Responsibilities:

• Performed day-to-day DBA jobs for managing 15+ Prod/Dev databases.
• Provide database administration on production, testing and development database servers.
• Estimate Storage requirement, Creation of Table spaces and other Database Primary Objects.
• Planning backup strategy and recovery procedures are sufficiently automated and documented.
• Migration of Oracle 8i Databases to 9i and 10g.
• Optimize creating indexes and views database performance by analyzing objects, generating statistics
• Standardizing Instance configuration of various Oracle 9i databases.
• Resolved production performance issues with poorly performing queries using tools such as Sql Tracing and Stats pack.
• Involved in Partitioning of very large tables using list and range partitioning.
• Implementation and Maintenance of Database Security. Major point of contact of database Users as and when required and administers their respective quotas. Create and Maintain Roles and assign necessary privileges to users according to business rules.
• Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
• Clone/Refresh of Production databases to Testing and training environments.
• Develop/customize shell scripts and Perl Scripts to automate routine DBA tasks of taking backups, exports/import, data pump and monitoring space availability and database performance database. Developed Standards for the developers.
• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.
• Creation of users and roles and maintaining system security.
• Monitor and Tuning of Database Performance by using various optimization techniques.
• Interacted with Oracle Support for resolving various critical database issues
• Employed various Oracle 10g Features/tools such as Automatic Database Diagnostics Monitor (ADDM), Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASS).
• Monitored All Servers using Oracle Enterprise Manager 10g Grid controls.

Environment:

Linux/Windows/HP Unix, Oracle 8.1.7.4/9.2.0/10.2, Toad, Stats pack, SQL Tracing, TKprof, Oracle Enterprise Manager, AWR, ADDM and J2EE application.

Database Sizes: 800GB

Client: Choice One BANK, MI                                                                                        11/01– 07/02

Role: Oracle DBA

AS one of the largest local commercial bank, Choice One Bank has near 1 TB data spreading across Oracle, SQL Server databases on Solaris, Linux, and WinXP server. DBA’s are assigned to support specific group of databases, but must support all databases during On-Call, Recovery and other special occasions. DBA’s are responsible for supporting the production and development environments, maintained 2 Oracle Instances on Sun.

Responsibilities:

• Supporting Testing, Development and Production environments on more than 30 UNIX servers.
• Troubleshooting Database issues for other vendors and users.
• Automation of monitoring, backups jobs.
• Configured Multi-Threaded Server (MTS) architecture for optimum usage of system resources.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Trained developers to optimize PL/SQL Procedures and SQL queries.
• Performed extensive database, application tuning for both production and QA databases to achieve high performance and scalability and was able to reduce sync up time from 10 hours to 2 hours.
• Setup automated collection of performance data using Oracle Stats pack utility and tuned Instance, application Sql, Indexes and tables to reduce contention on    resources.
• Extensive use of Enterprise Manager Tuning & Diagnostic Packs, Explain Plan, Sql Trace/Tkprof was made to achieve this scalable.

Environment:

Solaris/AIX, Oracle 8i/9i/10.2, Stats pack, SQL Tracing, TKprof, OEM and J2EE

Database Sizes: 800GB

Client: SCIL, India                                                                                                                            05/01 to 10/01

Role: Jr. Oracle DBA

SCIL is an International call center which carriers outsourcing activities with Telecom Companies like Sprint, Verizon, Cingular and Ampd and also SCIL is offers its expertise in the areas of Software development and Maintenance, building / re-building legacy applications with flexible engineering, providing ERP Solutions, Database Maintenance, Web based Commercial Technologies development.

Responsibilities:

• Supporting Testing, Development and Production environments on more than 30 UNIX servers.
• Troubleshooting Database issues for other vendors and users.
• Automation of monitoring, backups jobs.
• Password owner for all environments.
• Backup Strategies on Production databases.
• Configured Multi-Threaded Server (MTS) architecture for optimum usage of system resources.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Trained developers to optimize PL/SQL Procedures and SQL queries.
• Documenting all the processes followed in the production DB work.
• Designed structure to keep all the logical backups of important schemas.
• As an Infra Team Member got Recognitions in Team meetings for the work in the project.
• Appreciations for quick problem solving.
• Trouble shooting technical problems remotely at Customer Sites.

Environment:

Linux/Windows, Oracle 8.1/9.2,Oracle Enterprise Manager (OEM), Dot Net, SQL Tracing and TKprof
Database Sizes: 350GB

EDUCATION

Bachelor's Degree in Electronics and Communications Engineering