Senior Database Architect Resume
Somerset, NJ
SUMMARY
- Over 12 + years of experience in Software Industry with 9 years of experience in Oracle 11g/10g/9i/8i Database Administration on AIX/Unix/Sun Solaris/Windows platforms in ensuring quality, integrity and availability of the company’s data within oracle servers. Experienced in RAC.
- Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
- Well versed with Database Administration, Cloning Databases, Physical/Logical Standby Database, Backup and Recovery strategy using Hot Backup, User Managed and RMAN.
- Designing Database, tuning the Database, Database Security & Assigning the Roles, Profiles and Privileges to the various Users on Objects and Optimization by Explain Plan and SQL TRACE facility, Used other utilities like AWR, Statspack, and TKProf.
- 24/7 support for Production databases and responsible for round - the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior important.
- Administered Voting Disks and Services, Configured channels for Recovery Manager, Administered Cluster Registry, Managing Backup and Recovery in Oracle Real Application Cluster (RAC)
- Administered Disk groups and Instances in Automatic Storage Management (ASM).
- Used Oracle Enterprise Manager (OEM) for administering several databases
- Restored tables, schemas in test environments from export backups based on business requirements.
- Enabled Trace for specific user. Refreshed databases. Used expdp and impdp (Datapump).
- Leadership skills and Goal Oriented, Good Communication and Co-operation with the Teams, Management and Customers. Adept at learning and adaptable to complex work environment.
- Worked as a Lead for DBA team consisting of seven DBA’s
- Proven record of success in business development, operations, client management, benefit administration and project management
- Exceptional leader selected to participate in work-based mentoring program
- Completed a detailed course in Project Management (including LEAN Six Sigma Green Belt) at Rutgers University
TECHNICAL SKILLS
Databases: Oracle 11g, 10g, 9i and 8i
Tools: Oracle Enterprise Manager, SQL*Plus, STATSPACK, DBMS Packages, Export/Import, Datapump, SQL*Loader, RMAN, Logminer, BD Artisan, Oracle Fail Safe Manager, 3.3.2, Oracle Designer2000, PeopleSoft, OEM, OAM, Oracle Data Guard, Oracle Universal Installer, Oracle Configuration Assistant, BMC patrol, Power Builder, PL/SQL, Erwin3.5, Toad, Tivoli Storage Manager, 4.2.1, Tivoli Data Protection, 3.3.2. and Veritas Volume Manager, HP Open View, Big Brother, Jobit and Logit.
Operating Systems: Sun Solaris 10,8/7 Aix 5.3/5.2/4.3, Redhat Linux AS 4/2.1, HP UNIX 11/10 and Windows.
Languages: C, FoxPro 2.6, SQL, PL/SQL, UNIX Shell Scripting, SAS, OS/MVS JCL, SQL, COBOL I and II, DB2, Visual Basic.
Data Storage: Veritas Volume Manager (VVM)
Hardware: IBM 3090, IBM 3270 IBM PC, HP-UX 11.11; Hardware HP-UX Sparqnet servers (HP RP5470), Windows NT &Windows 2000 server
Methodologies: Rational Unified Process (RUP), Waterfall Method
Microsoft Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, MS Project Servers, Windows SharePoint Services.
Concepts: Problem Analysis, Structured Programming Design & Techniques, Debugging, Database & File Manipulation, Table Handling
PROFESSIONAL EXPERIENCE
Confidential, Somerset, NJ
Senior Database Architect
Responsibilities:
- Installed cluster binaries 11.1.0.6.0 using shared file system on SUN servers
- Installed 11.1.0.6.0 Oracle RAC database software to implement Applications on sun4u machines with Solaris 10 operating system.
- Successfully led the migration team with database and application teams.
- Installed 11.1.0.6.0 version Oracle Binaries on CRS cluster 11.1.0.6.0 supported by raw devices with ASM and created related Disk groups in support with the Engineering team.
- Performed Oracle CRS and Database Binaries upgrades from 11.1.0.6.0 to 11.1.0.7.0 for TMO.
- Implemented Flashback database and Flashback concepts as per the requirements..
- Planned and configured Automatic Memory Management.
- Implemented BCTF to fine tune backup window.
- Estimated the size of the FRA during configuration of FRA.
- Implemented Datapump and RMAN to migrate data from PROD to other environments
- Designed backups using RMAN and Datapump, and implemented RMAN compression for space optimization.
- Configured standby database and tested RTO for switchover and failover scenarios.
- Designed the procedures, developed the scripts and implemented processes for DR test from tapes at the DR site.
- Monitored production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
- Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR, ASH and ADDM.
- Worked closely with application developers and system administrators to ensure all database needs are being met.
- Documented Tech Specs for the proposed data base design.
Confidential, Manhattan, New York
Senior Database Administrator
Responsibilities:
- Support more than 30 Oracle 10g RAC/ASM, 9i database instances as primary DBA (PROD/DR/QA/DEV). Provide 24x7 support for Production databases.
- Install and upgrade Oracle software using OFA structures. Applying patches and bug fixes.
- Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs.
- Manage both OLTP and data warehouse databases that have more than a thousand of concurrent user sessions and over terabytes of data.
- Creation of different DBA/APP/USER schemas and setup proper user profiles. Grant/revoke certain sys/object privileges to meet bank security and audit requirement.
- Build/Repair Standby databases/Data Guard using RMAN restore and duplicate command.
- Perform Oracle performance tuning and monitoring using Oracle OEM/AWR/Quest tools.
- Recover user errors using both Oracle Flashback based recovery and also time based incomplete recovery by applying archived redo logs from the Veritas Netbackup tapes.
- Migrated Automated and Monitoring jobs from CRON TAB to AUTOSYS jobs to perform RMAN database disk and Netbackup tape backup.
- Implement systems with 24x7 high availability using different methods including Oracle RAC/Standby/IBM HACMP and EMC SRDF.
- Work with developer in designing database tables, partitioning/indexing, developing PL/SQL stored procedures, triggers and performing queries optimization.
- Troubleshoot DB issues and provide immediate response for critical Production databases. Reach out to Oracle technical support through Metalink and service request TARs.
- Tune SQL slow statement by collecting/setting cost based optimizer statistics and also using hints to accommodate some particular queries.
- Implemented Data pump to replace EXP/IMP.
- Set up and maintain company standard db scripts and documentation for new Oracle databases build.
Confidential, NY
Senior Oracle Database Administrator
Responsibilities:
- Involved in development of FNX application at all stages including data modeling and deployed FNX application to the Production.
- Installation and configuration of Oracle Real Applications cluster (RAC) 9.2.0.7. Used shared file system to support nodes in the cluster.
- Implemented DBCA to build Real Application Cluster (RAC).
- Configuration of system to achieve High Availability, Load balancing.
- Partitioned some of the large database tables.
- For better performance of the System implemented stripping at storage (EMC) level and Operating System level.
- Implemented RMAN Backups, Creation of catalog database, Developed RMAN scripts and tuned various parameters. Developed the scripts to monitor multiple databases and generate reports from single server.
- Extensively worked on OEM (Oracle Enterprise Manager).
- Performed Cloning and data refresh from Prod to QA and DEV databases.
- Data Migration from AS-400 system to Oracle 9.2.0.5.
- Involved in resolving database and application problems. Highly experienced in troubleshooting problem queries that take long.
- Implemented the database tuning to improve the performance of the database using the Perfstat package and DBMS.STATS Pack.
- Migration from 8.1.7 to 9.2.0.5.
- Implemented Standby Database for all the Production databases.
- Developed the Structure of Tablespaces and planned the data distribution for the FNX application.
- Erwin tool was used for some of the databases for data modeling.
Confidential, Moline, IL
Database administrator
Responsibilities:
- Installed the Oracle 8.1.6/8.1.7 RDBMS on servers and configured the databases for Client/Server architecture.
- Involved in Technical Requirement Analysis for various systems and Review Project Documents with Client.
- Designed and managed all aspects of development, test and production databases.
- Configuring the Oracle Networking environment using Oracle Net and Net8.
- Migrated Oracle database 7.x.x to 8.1.7.
- Developed the scripts for Hot and cold Backups.
- Performed Backups using RMAN.
- Performed Oracle Database Cloning from Production to Test and Development databases as per client requirements.
- Implemented the database tuning to improve the performance of the database using the Perfstat package.
- Configured the database in the ARCHIVE LOG mode in order to run the ARCH process for archiving updates and changes to the database.
- Migrated databases from No Archive Log mode to Archive Log Mode.
- Interacted with the developers to improve the Server performance and User Business requirements.
- Developed the database triggers for business functionality.
- Active member of the on-call team to support Clients of different Industries relating to our team 24/7, to keep the High critical systems running.
Confidential, Fort Lee, NJ
SAS Programmer/Analyst
Responsibilities:
- Identify and implement solutions aimed at enhancing operational efficiencies resulting in reduced costs and/or increased revenues
- Review functional requirements documentation and translate functional requirements into technical specifications
- Analyze and document complex business problems and formulate solutions by composing and executing SQL queries
- Research, analyze, maintain and document specific operational issues. Enhance processes to resolve existing system/process issues
- Developed a rules engine to map inbound client data to the Sasbase structure and subsequently deploy data to vendors/clients in a flat file format
- Facilitate information sharing and process improvement across various Data Management groups
- Improve Metrics and Reporting by performing root cause analysis and enhancing service delivery
- Participate in the successful transition of work to offshore vendor(s)
- Train new employees on client responsibilities to ensure a smooth transition
- Produced new interfaces for eligibility files on client projects
- Updated current interfaces by request of business analyst and/or client
- Acted as a liaison with vendors by coordinating meetings & negotiating relationships
- Assisted business teams with understanding and implementing IT solutions to meet FMLA, HIPAA, and COBRA requirements
- Lead the client implementation team for American Express