POSTGRESQL RESUME EXAMPLES
Resume Builder
Edit this resume to make it your own!

Your Name

Atlanta, GA

your.email@example.com
111-222-3333
www.your-website.com

Work Experience

Independent Oracle Consultant

BIAS Corporation, Atlanta, GA

Dec 2012Current

Consulting on Oracle products related to Databases in Southern Company.

Oracle Exadata, Trouble shooting and Performance Solutions Exadata performance analysis and trouble shooting and found solutions regarding the same.
 
Oracle DW and OLAP implementation and Performance Tuning Implemented OLAP solutions for Data Warehouse and did trouble shooting and solutions related to performances in data warehouse environments 

Oracle Database upgrade, 10g to 11g Upgrade projects of database clusters from 10g to 11g to take into account the functionality of 11g databases. Tune the queries for performance. 
 
Oracle Database Data Guard solutions Implemented Physical and logical standby databases  
Oracle Database migrations from Solaris to Linux.

Sr. Principal Architect

Oracle Corporation, Atlanta, GA

Nov 2010Dec 2012

Analyze business needs to help ensure Oracle solution meets the customer's objectives by combining industry best practices, product knowledge, and business acumen. Exercise judgment and business acumen in selecting methods and techniques to deliver functional and technical solutions on non-routine and very complex aspects of applications and technology installations. Provide direction and mentoring to project teams, and effectively influencing customer leadership on key decisions. Support the business development efforts by pursuing new opportunities and extensions. Collaborate with the consulting sales team by providing domain expertise.

Oracle Database Upgrade, Exadata
  • Multiple Clients initiated the upgrade projects to take advantage of new functionality of Exadata for the data warehouse databases. Using the multi node RAC and moving to different levels of Exadata solutions.

Oracle Exadata, Trouble shooting and Performance Solutions
  • For Multiple Clients did Exadata performance analysis and trouble shooting and found solutions regarding the same.

Oracle DW and OLAP implementation and Performance Tuning
  • Multiple Clients implemented OLAP solutions for Data Warehouse and also did a lot of trouble shooting and solutions related to performances in data warehouse environments

Oracle Database 12c implementation, upgrade and configuration
  • Studied and implemented 12c Cloud technology, also upgraded existing databases to 12cR1 and implanted as Plug-in databases into the system. Also know about new features of 12c databases on other aspects of database technologies

Oracle Database upgrade, 10g to 11g
  • Upgrade projects of database clusters from 10g to 11g to take into account the functionality of 11g databases.

Oracle database upgrade, 9i to 10g cluster
  • Upgraded all the databases from 9i to 10g cluster. Implemented the cluster ware configured ASM, implemented 10gR2 database binaries and migrated all the databases from 9i to 10g. Also as a follow up had to tune the queries for performance.

Oracle Database implement standby databases
  • Implemented Physical and logical standby databases for Multiple Clients for Oracle 10g, 11g and Exadata. Implemented data guard database for MAA for 10g, 11g and Exadata.

Oracle Database implemented backup strategies
  • Implemented different backup strategies, from export and import to RMAN having different backup devices from Tape to physical and virtual hard drives

Oracle Database Tuning Strategies
  • Implemented tuning of Oracle databases and related processes like ETL etc. after analyzing the involved processes. Did all levels of tuning from database to query to process etc. SQL tuning and SQL Analysis. Also did Tuning for DW and Exadata machines as mentioned above

Oracle Big Data Appliance
  • Has worked on Oracle Big Data Appliance for a POC at P&G. Did data loading on hive tables created queries for analysis purposes. Administered the Big Data Box.

Sr. Oracle DBA

Cox Communications, Atlanta, GA

Dec 2008Sep 2010

  • DBA: All round database activities as a project and production DBA
  • Extensive Performance tuning and daily maintenance activities both on database and OS.
  • Maintained database in Exadata Systems
  • Migrating databases from Oracle 10.2.0.3 to Oracle 11.2.0
  • Creating new clusters in Oracle 11.2.0 along with ASM and databases
  • Involved in redesigning of the database layouts.
  • Migrating databases not in 10g to 10.2.0.3
  • Moving the databases to ASM from normal file set up.
  • Creating RAC systems depending on the type of database ranging from 1 node RAC to 6 node RAC a total of 50 in numbers.
  • Consolidating small databases into single database on a RAC system.
  • Testing Backup procedure on newly created databases.
  • Making and implementing backup plans for the production databases using RMAN.
  • Automated a number of processes related to space maintenance and RMAN digests.
  • Creating Logical and Physical Standby Databases and Data Guard both using OEM and manually.
  • Maintaining multiple standby databases of both logical as well as physical.
  • Creating and maintaining QA and Development environments for every production database
  • Doing performance reviews and performance analysis from time to time
  • Doing full product life cycle (Database portions) right from inception to testing, tuning and final production deployment.

Sr. Oracle DBA Consultant

Boden Inc, Atlanta, GA

Dec 2005Dec 2008

  • DBA: All round database activities as a project and production DBA
  • Extensive Performance tuning and daily maintenance activities both on database and OS.
  • Migrating databases from Oracle 9i to Oracle 10g
  • Creating new clusters in Oracle 11.2.0 along with ASM and databases
  • Involved in redesigning of the database layouts
  • Testing Backup procedure on newly created databases.
  • Making and implementing backup plans for the production databases using RMAN.
  • Automated a number of processes related to space maintenance and RMAN digests.
  • Creating Logical and Physical Standby Databases
  • Implemented Oracle Data Guard
  • Maintaining multiple standby databases of both logical as well as physical.
  • Creating and maintaining QA and Development environments for every production database
  • Doing performance reviews and performance analysis from time to time
  • Doing full product life cycle (Database portions) right from inception to testing, tuning and final production deployment.

Sr Consultant

NIIT Technologies, New Delhi, Delhi

Feb 2005Dec 2005

  • DBA: Worked as production DBA
  • Maintaining databases for British Airways on different applications having more than 200 GB data on an average.
  • Performing duties as Oracle DBA to support Oracle 8.1.X and Oracle 9i databases running on Sun Solaris Platforms Involved in Database Design, Database Porting, Performance tuning, PL-SQL tuning, Backup and recovery
  • Did some Shell scripting and Perl scripting at the UNIX level for certain operations to be performed using crontab.
  • OS: Maintain space and file systems of all the servers i.e. Solaris and Windows.

Oracle DBA

Boden Software Services, Hydrabad, India

Feb 2004Feb 2005

Doing database activities for Telstra Project, Australia, on Siebel Application
  • DBA: Worked as project DBA for upgrading database and implementing and maintaining integrities for Siebel Application
  • Maintaining and creating new databases for Telstra on Siebel application having more than 200 GB data on an average.
  • Performing duties as Oracle DBA to support Oracle 8.1.X and Oracle 9i databases running on Sun Solaris Platforms
  • Involved in Database Design, Database Creation, Database Porting, Performance tuning, PL-SQL tuning, Backup and recovery
  • Resolved many oracle performances and tuning issues involving disk tuning.
  • Did some shell scripting at UNIX level for certain operations to be automated
  • Taking Hot and Cold backups of different databases.
  • OS: Maintain space and file systems of all the servers i.e. Solaris and Windows.
  • Environment: SUN Solaris 2.7, E450/E250, Ultra 10, SUN Fire, Oracle 9.0.5, 9i, 8i, 8.1.7, 8.1.6, 8.1.5, 8.0.5, Oracle Enterprise Manager, SQL Loader, Apache Web Server, SQL Plus, Oracle Utilities, Siebel Application.
  • Doing database activities for Hitachi Project, USA, on BAAN CRM Application
  • DBA: Worked as project DBA for upgrading database and implementing and maintaining integrities for BAAN CRM application
  • Manually upgrading Oracle database at the server level from 8.0.5.2 to Oracle 9.2.0.5.
  • Changed the character set from WE8 to UTF
  • Tracking that the customizations on the database remain intact as BAAN CRM is upgraded from version 4.21 to version 4.3SP4.
  • Tracking that all the objects and data remains consistent during the database and application up gradation.
  • At the client level SQLBase database has to be upgraded to MSDE database again keeping all the customizations intact.

Database Administrator

CMS Computers Ltd, New Delhi, Delhi

Apr 2000Feb 2004

  • DBA: Worked as production DBA
  • Creating databases and maintaining the same for Airtel users.
  • Performing duties as Oracle DBA to support Oracle 8.1.X databases running on Sun Solaris E250 and E450 for Airtel Tango.
  • Oracle 9i installed on Linux Server for Airtel Services, Number Management, Group SMS etc.
  • Maintaining database Oracle 8.1.X running on Linux machine for International Roaming subscribers.
  • Involved in Database Design, Performance tuning, PL-SQL coding, and performance tuning.
  • Installed and maintaining Postgres Databases on Linux machines for Group SMS and 7001 services of Airtel.
  • Installed Tomcat and Apache web server on Sun E450/250 machines.
  • Did some Shell scripting and Perl scripting at the UNIX level for certain operations to be performed using crontab.
  • Resolved many oracle performances and tuning issues involving disk tuning.
  • Worked with developers with Oracle issues and assisted in SQL tuning and PL-SQL coding for SQL Plus
  • Maintained and tuned Postgres. database
  • Cold Backup and recovery without RMAN for Group SMS.
  • Maintaining the Linux 7.1 servers, maintaining Airtel services.
  • This includes activation and conversion of the older 16K SIM to newer 32K SIM.
  • OS: Maintain space and file systems of all the servers i.e. Linux, Solaris and Windows.
  • Shell scripting for different jobs to be performed.
  • The above includes maintaining RAS, switches, routers and Checkpoint firewall.
  • Creating the databases and maintaining the same for WAP over GPRS users.
  • Performing duties as Oracle DBA to support Oracle 8.1.X databases running on Sun Solaris E250 for Idea GPRS users.
  • Involved in Database Design, Performance tuning, PL-SQL Coding, database procedures and triggers and performance tuning.
  • Did some Shell scripting and Perl scripting at the UNIX level for certain operations to be performed using crontab.

Education

Masters in Business Administration in Marketing

Aligarh Muslim University, Aligarh, Uttar Pradesh

19941996

Bachelor of Sciences in Chemical Engineering

Aligarh Muslim University, Aligarh, Uttar Pradesh

19901994

Skills

Oracle Database Administration, Oracle Database Architect, 11g RAC, 10g RAC, Exadata, OEM, RMAN backup and recovery, Streams, DR, Dataguard, OLAP, Big Data, Hadoop

Additional Information

With over a decade in the different industry and worked as Principal Architect DBA on different versions and functionalities of Oracle databases like, but not limited to, 12c Cloud and Plug-in database, Oracle ASM multi-Node 11g RAC or Grid, Exadata V2 and X2, 10g RAC, Oracle 9i, Oracle 8i, Oracle 8 and Oracle 7 in different capacities both as project DBA and support and maintenance DBA, have over 12 years of experience in administering databases in online, production, pre-production, development environments on Solaris, Windows, Linux, AIX, HPUX platforms. Also have extensive experience in migrating databases, from very small to very large sizes. Have experience in implementing and managing multi-node RAC along with ASM and non-ASM for 10g, 11g and 12c. Implemented Streams and other DR solutions on different versions of Oracle RAC environments. Implemented and managed Data guard on Oracle 10g and 11g RAC and Exadata. Also worked on Enterprise SAN and cross-platform migration. Have experience in managing Oracle Fail safe manager. Effective maintained patch versions and installed required patches on the database. Maintain security according to best practices and generate security solutions that balance auditor requirements with user requirements. Also have experience in handling Oracle Big Data appliance and Hadoop. Have managed database in Postgres as well.
Powered by Super-Resume