Database Administrator Resume
TN
SUMMARY
- Accomplished Database Administrator with demonstrated success in designing and implementing solutions. Expertise in performance tuning, high availability to increase reliability, maximize productivity, and introduce system efficiencies.
- 9+ years of experience as Oracle Database Administrator, providing 24X7 production and development support 11g/10g/9i databases on different platforms including RedHat Linux, Windows, Oracle Linux
- 9+ years of experience with Oracle 9i/10g/11g Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
- 3+ years of experience with PostgreSQL 9.2 Installation, Administration, Monitoring, Tuning, Backup and Recovery.
- 3+ years of MySQL experience with Installation, Administration, Monitoring, Tuning, Backup and Recovery
- 7+ years of performance tuning expertise. SQL Tuning, Instance Tuning, PL/SQL Procedures & Packages Tuning
- 8+ years of experience in creating primary database storage structures (Tablespaces), primary objects (Tables, Views and Indexes) and with creating users, Roles and Profiles.
- Scripting Experience with Shell (6 years), Perl & Python (2+years).
- 1+ Years of MongoDB experience. 1+ years of Cassandra Administration experience.
TECHNICAL SKILLS
Operating Systems: RedHat Linux RHEL 4.x, 5.x, 6.x, Oracle Linux and Windows 95/98/ME/NT/2000/XP/Vista7/8.
DataBase: Oracle 11g/10g/9i, PostgreSQL 9.2, SQL Server 2000, Mongo DB, Cassandr, MySQL
Languages: SQL, PL/SQL, UNIX Shell Programming, PERL Scripting, JAVA
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
Database Tools: RMAN, OEM, SQL*Loader, Data Pump, Export/Import, TOAD, OEM Grid Control, SQL*Plus, DBCA, Oracle SQL Developer, PL/SQL Developer, pg dump, pg restore, psql
ETL Tools: Informatica, Pentaho Data Integration
Modeling Tools: Visio, ERwin
Version Control: Clearcase, CVS, Subversion (SVN), VSS, GIT
Defect Tracking Tools: JIRA, TrackRecord
Application/Web Servers: Apache Tomcat 5.x.
Other Skill - sets: Hadoop, Big Data, Cassandra, Shareplex Replication
PROFESSIONAL EXPERIENCE
Database Administrator
Confidential, TN
Responsibilities:
- Primarily involved in creating/upgrading and maintaining Oracle 11g Databases on Oracle version 11.2.0.4
- Performed manual out of place upgrade of all Oracle Production Databases from 11.2.0.3 to 11.2.0.4.
- Supported medium (200 GB size range) to very large databases (1.5 TB size range) in a 24x7 support environment (on-call).
- Worked with developers and architects with physical data design to meet the core business requirements of the EHR application.
- Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Identified and fixed performance bottlenecks on the Carelogic Application that arose as part of the Oracle DB upgrade and regular weekly builds.
- Install and configure Shareplex replication used for reporting.
- Developed capacity and performance metrics as well as maintain, analyze, and report on the overall health of the databases.
- Documentation of all standard operating procedures required for the daily maintenance of the databases.
- Implemented scripts for proactive space monitoring and effective space allocation for both Oracle & PostgreSQL.
- Part of the change control team as part of Operation in assessing the weekly build release.
- Applied the weekly build to all Development, QA, Certification and Production environments using automated PERL scripts.
- Automated the standup of new Certification & Production environments using Shell scripts and Windows batch scripts.
- Performed POC using RMAN Duplicate to copy data from Production to the Certification environment.
- Currently working/planning on migrating the Production standalone databases to RAC for High availability.
- Upgraded all DEV/QA/UAT/PROD databases from 11.2.0.4.4 to 11.2.0.4.7 using Opatch to fix library cache issues.
- Installed and maintained MySQL 5.5 databases used in reporting.
- Performance tune and benchmark MySQL databases.
- Create automated backup shell scripts for the backup of all databases using mysqldump, incremental backup using logs.
- Well versed with MyISAM & InnoDB storage engines and their pros & cons.
- Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
- MySQL processes and queries optimization.
- Converted databases from MyISAM format to Innodb storage engine for databases that needed greater referential integrity.
- Installed and maintained PostgreSQL 9.2 databases for migrating the reporting from OLTP to a warehouse environment.
- Setup and maintenance of pgPool for load balancing and replication across all database nodes.
- Performance tune and benchmark PostgreSQL databases.
- Created automated backup shell scripts for the backup of all databases using pg dump, pg backup.
- Performance tuned the Postgres Warehouse database Instances to improve the performance of ETL data loads and frond end reporting.
- Modified parameters in postgresql.conf, added indexes, and tuned queries to help in improving performance.
- Created PL/pgSQL scripts for the maintenance of the databases.
- Created shell scripts for the ETL jobs to be executed using Kitchen connecting to Oracle and loading data into the Postgres Databases.
- Well versed in creating the primary storage structures (Tables, Views, Sequences, Functions, Tablespaces & Indexes).
- Installed Cassandra for a POC implementation to convert one of the Applications from Relational Database to No SQL.
- Created 3 and 4 node clusters and modified Cassandra.yaml according to the specific requirements.
- Used CCM & Nodetool to manage/monitor the nodes.
- Used CQLsh to create keyspaces and load the keyspaces.
- Used Cassandra Stress to monitor the performance of the data load activity across the nodes.
- Implemented different replication levels and consistency levels for data read/data write.
- Basic understanding of Hadoop concepts & framework.
- Assisted in designing, development and architecture of Hadoop systems.
- Supported technical team members for automation, installation and configuration tasks.
- Provided technical assistance for configuration, administration and monitoring of Hadoop clusters.
Environment: Oracle 11.2.0.4, Windows Server 2008/2003, Oracle Linux, RHEL, PL/SQL, Oracle Application Server, Pentaho DI, Pentaho BA, pg dump, pg stat, pg restore, Shareplex, Cassandra, MySQL
Database Administrator
Confidential, Nashville, TN
Responsibilities:
- Primarily involved in creating databases for MMIS on RHEL environment with Oracle version 11.2.0.3
- Developed & maintained Stored Procedures, Packages and Functions.
- Expert in Oracle Performance Tuning, SQL Tuning/Optimization, RAC Instance Tuning.
- Involved in creating modeling and development environment that uses Unified Modeling Language (UML) for designing architecture of the MMIS application.
- Assisted in designing the logical & physical Data Model of the MMIS application.
- Assisted developers and architects with physical data design to meet the core business requirements of the MMIS application.
- Managing database security by creating and assigning appropriate roles and privileges to users depending on user activity.
- Developed shell scripts to automate database monitoring.
- Designed and implemented the backup / recovery for production database environments using Shell Scripts / SQL. Automated the database backup.
- Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Experience in Identifying performance bottlenecks on high volume transaction systems.
Environment: Oracle 11g, Window 7, PL/SQL, SQLLDR, Datapump, OEM, ADDM, AWR, SQL, Explain Plan, TKPROF, IBM Clearcase, IBM RSA.
Database Administrator
Confidential, Nashville, TN
Responsibilities:
- Primarily involved in maintaining the Data Model of the Eligibility System developed for DHS (Department of Human Services) involving more than 1600 tables.
- Assisted in designing the logical & physical Data Model of the application using Erwin.
- Expert in Oracle Performance Tuning, SQL Tuning/Optimization, RAC Instance Tuning.
- Led the Performance Tuning team comprising of 5 members. Actively involved in reducing runtimes of large SQLs, modifying database level parameters to improve the efficiency of the batch jobs.
- Involved in tuning the Conversion database Instances to improve the performance of ETL data loads.
- Involved in tuning the SQL called from ETL mappings in Informatica to improve the speed of data fetch from the source schema.
- Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Provided support on performance issues during project development resulting in improved response times and reduced contention
- Experience in Identifying performance bottlenecks on high volume transaction systems.
- Implemented table partitioning & index partitioning to improve performance and data management in the conversion database. Also used parallelism to improve performance.
- Developed & maintained Stored Procedures, Packages and Functions required for Data Conversion from legacy systems.
- Assisted with the impact analysis of any changes made to the database objects and troubleshoots problems regarding the databases, applications and development tools.
- Installation and configuration of Oracle 10.2.X server and creation of databases.
- Performed SQL tuning by using Explain Plan and Tkprof. Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
- Developed scripts to automate backup of development and test databases. Monitored system backups and re-run as necessary and also processed requests for schema restore.
- Review system logs to identify signs of potential problems
- Refreshed development & test databases using Conventional Export/Import after every build of the application.
- Implementing range, list partitions, hash sub partitions.
- Creating and refreshing materialized views.
- Involved in loading large amount of data from text files into tables using SQL Loader.
- Experience in managing Partitioned & Non-partition tables & indexes, tablespaces, database files, redo log files, control files, parameter file, views, sequences and other database objects.
- Aided developers in writing efficient SQL leading to better performance and optimization.
- Managing database security by creating and assigning appropriate roles and privileges to users depending on user activity.
- Defragmentation of tables and indexes for improved performance and effective space management.
- Troubleshoot Database & Application performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
- Used Oracle Enterprise Manager (OEM) Grid Control to maintain and monitor multiple databases on multiple hosts.
- Assisted in analyzing all ETL mappings to find out performance bottlenecks based on fetch queries and fixing them by adding appropriate indexes.
- Work with the development ream to maintain documentation of technical design documents and other project deliverables.
Environment: XML, Oracle 10g, Windows 95/98/ME/NT/2000/XP, PL/SQL, Informatica Powercenter Designer, Informatica Powercenter Workflow Manager, Informatica Powercenter Workflow Monitor. SQLLDR, Datapump, Erwin, OEM, ADDM, AWR, SQL, Explain Plan, TKPROF, Visio.
Software Engineer
Confidential
Responsibilities:
- Responsible for ensuring support for configuring & installing of databases.
- Responsible for 1st, 2nd and 3rd tier support for assigned applications.
- Diagnose and resolve complex operating system, application software, security, hardware or other related problems that impact system availability.
- Work with the development ream to maintain documentation such as user guides, systems administration manuals, maintenance manuals, technical design documents and other project deliverables.
- Perform and provide end-user support, systems and business analysis, documenting business processes and systems requirements.
- Analyze and discuss the business requirements with the clients.
- Responsible for the development, implementation and support of the database.
- Optimized and modified the triggers, complex stored procedures, functions.
Environment: XML, Oracle 10g, Windows 2000/XP, PL/SQL, SQLLDR, Datapump, Erwin, OEM, ADDM, AWR, SQL, Explain Plan, TKPROF, RedHat Linux RHEL 4.x,Mandriva
Developer / Administrator
Confidential, Carbondale, IL
Responsibilities:
- Mainly responsible for maintaining the Mainframe database used for Student Admissions
- Involved in database development tasks using SQL database programming.
- Involved in database administration and management by using knowledge of PL SQL programming.
- Managing security of the Oracle database by creating and assigning appropriate roles and privileges to users depending on user activity.
- Mentored junior programmers in Oracle database design and development.
- Generated SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
- Documented functional and technical designs, test cases, and user guides.
- Troubleshooted performance issues and bugs within packages, procedures using DBMS OUTPUT, Explain plan and TKPROF.
- Wrote database PL/SQL triggers and procedures to provide backend security and data consistency.
- Installed Oracle 9i/10g on Linux & Windows environments along with Oracle client tools and established connectivity to databases.
- Developed Web pages using Dreamweaver, HTML.
Environment: XML, Oracle 10g, Windows 95/98/ME/NT/2000/XP, PL/SQL, Erwin, OEM, ADDM, AWR, SQL, Explain Plan, TKPROF, Dreamweaver, MS Frontpage, HTML
Associate Consultant
Confidential
Responsibilities:
- Involved in performing ETL on the OLTP data to load them in to the data warehouses using MS SQL Server 2000.
- Developed PL/SQL programs for data manipulation.
- Installation of Oracle client tools and establishing connectivity to databases.
- Created reports using Informatica and Business Objects.
- Wrote queries and stored procedures necessary for the given modules
- Responsible for maintenance and bug fixes
- Developed complex stored procedures, Views in T-SQL
- Installed Oracle 9i/10g on Linux & Windows environments.
- Unix and Linux System administration, and network, utility and user interface programming.
- Involved in backup & recovery of databases. (Team Size 6).
- Worked in OEM database control to manage & monitor the databases.
Environment: XML, Oracle 10g, SQL Server 2000, Oracle 9i, Windows 95/98/ME/NT/2000/XP, PL/SQL, Informatica Powercenter Designer, Informatica Powercenter Workflow Manager, Informatica Powercenter Workflow Monitor. SQLLDR, Datapump, Erwin, OEM, ADDM, AWR, SQL, Visio, Business Objects, Crystal Reports
