SUMMARY

• Confidential TEMPhas 9 years of experience as an ORACLE and SQL DBA/Data Architect and an Oracle Certified Professional (OCP certified) from Oracle University. Confidential possesses the skills to quickly adapt to any environment during any point of the project cycle and provide efficient response to company deadlines and system complications.
• Confidential is an energetic self - starter with excellent organizational, analytical, and creative skills with an extremely in-depth noledge of the Oracle database and other products.
• Oracle 8i, 9i, 10g, 11g, 12C and 12C Cloud OEM
• MS SQL Server 2005, 2008 and 2012
• Installation, configuration and upgrading of Oracle server software and related products in Unix (Sun Solaris 10, Linux, AIX, HP) and Windows
• Installation, configuration and maintenance of MS SQL server
• Experience in AWS, cloud deployment and server virtualization technology using Oracle VM Manager and Oracle VM server
• Experience in DevOps environment, installing, configuring and automating build, deployment, infrastructure setup and delivery
• Experienced working in Agile methodology using Scrum Framework, a Certified Professional Scrum Master and performed additional role as a Scrum Master
• Installation of WAS, WLS and OAS
• Evaluation and assessment of Oracle features and Oracle related products
• Establishing and maintaining sound backup and recovery policies and procedures
• Disaster Recovery - Data Guard and RMAN
• Experienced in the database development lifecycle
• Experienced in automated database deployment using uDeploy
• Experienced in Database design and implementation
• Experienced in performing database tuning and performance monitoring
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Patch Management and Version Control
• High Availability - Real Application Clusters (RAC) & Automatic storage management (ASM)
• Setup and maintenance of documentation and standards
• Planning growth and changes (capacity planning)
• Worked as part of a team and provided 24x7 support when required
• Performing general technical trouble shooting and providing consultation to development teams
• Interfaced with Oracle Corporation for technical support
• Provided training on basic database concepts to Development and QA teams

TECHNICAL SKILLS

Database and Application Servers: Oracle 8i, 9i & 10g, 11g, 12c Cloud OEM & MS SQL server 2005, 2008, 2012, WLS, WAS, OAS

Operation System: Unix (Solaris, Linux, AIX, HP), MS Windows 95/NT/2000/2003/XP/2008 SP2

Languages: C, Shell Scripting, SQL, PL/SQL, HTML, Java Script, XML, Batch Scripting, ANT

Workflow tools: MS-Excel, MS-Word, MS-PowerPoint, MS-Visio2000

DevOps Tools: GIT, Jenkins, Maven, Ant, Nexus, Docker

PROFESSIONAL EXPERIENCE

Confidential

Oracle and SQL Database Administrator

Responsibilities:

• Installation, configuration, and administration of database and application/web server software.
• Creation of new databases, schemas and table spaces as well as application of developer corrections to existing environments.
• Installation, configuration and administration of application servers
• Tier 2 supports for customer based installs as needed.
• Designing logical and physical databases, reviewing database design changes and assessing impact of changes, calculating optimum database parameters, designing indices, monitoring database performance, performance tuning, establishing and administering database security, and modeling data.
• Install, upgrade and configure company products (Customer Suite, Asset Suite, eSOMS).
• Providing developer support on batch data update process and workflow. Worked with Technical Architects on new development activities and troubleshooting tasks.
• Documented DBA processes and provided assistance for internal DBA trainings, instructions and materials development.
• Evaluated new releases of Oracle and SQL Server and recommended the feasibility of version upgrades for company supplied products.
• Worked with IT to meet the backup, configuration and retention needs for multiple environments and platforms.

Confidential

Oracle and SQL DBA

Responsibilities:

• Involved in planning, designing & implementing the tool
• Maintaining MS SQL Server by creating database & instances
• Integrating IMS with Service desk plus
• Installing & configuring Microsoft exchange server with service desk plus
• Documentation of the entire product end-to-end release

Confidential

Oracle DBA Consultant

Responsibilities:

• Responsible for installation, upgrade, refreshing, account management, backup/recovery, performance tuning of Oracle 8i, 9i & 10g databases on Solaris & windows
• Responsible for providing 24x7 support for test servers & production Oracle databases
• Installing and upgrading the database server and application tools
• Plan for backup, recovery, and restoring the database
• Control and monitor user access to database; monitor and optimize the performance of database
• Database programming including stored procedures using PL/SQL
• Write complex SQL queries for performance improvement
• Allocate system storage using automatic storage management (ASM) and plan for future storage requirements for the database system
• Provide technical resolution to Oracle database related problems
• Create primary database storage structures and primary objects
• Assisted in logical and physical database design
• Developed & modified some Oracle backup and recovery by using shell scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. dis includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, checking for errors in alert logs and trace files, etc.
• Setting up the local DB Servers for the team using both OS (windows & Solaris)
• Managing App Servers of ATG and Web sphere
• Managing Web Servers of ATG and Web sphere
• Building and deploying the ATG & Web sphere code
• Handling web method servers for each application
• PVCS management - Creating Branch for the specific release, User management, Merging the code
• Generating crystal reports using BOE server.
• Upgrading JDK or Java version on Solaris