SUMMARY:

• Over the 18+ years of professional experience as an Oracle Developer/DBA, I had numerous opportunites to work with Business Analysts.
• I have the knowledge and expertise for what takes to be a BA - gather technical/functional rules, requirements from business, estimate the technical aspect/business value, be a bridge between development teams, DBA’s, Testers, Stakeholders, Project managers and business functionality, work towards goals various deadlines and ofcourse most importantly prioritize the needed changes.
• Over my career I had been in thousands of meetings that would entail these discussions.
• Experienced in Agile environment, used numerous tools such as Jira, source code Visual studio, subversion, ERwin etc.
• My background with databases(systems side), database physical objects, UNIX, ETL/job processes, Data modeling and various other methodologies would come in handy and cater to these needs.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Chesterfield, MO

Responsibilities:

• Oracle 12c, Windows OS, Physical/Standby setup
• Create databases for new customers
• RMAN backup/recovery, Data pump export/import, off-site Disaster recovery servers
• ERwin Datamodeling, Visual Studio source code management
• Routine Schema management, SQL tuning
• Windows Task scheduler, jobs/Alerts reporting

Oracle Application DBA

Confidential, St. Louis, MO

Responsibilities:

• ETL process support- production support/nightly batch runs, Autosys scheduler
• Design, develop, implement monthly releases & Project work
• Datamodeling(Power Designer) - design and translating conceptual to Physical.
• Creating Schema objects for applications - Tables/Indexes, Triggers, Packages, Functions etc
• Password/SOX compliance, documentation
• Making database changes per audit recommendations
• Working with multiple databases on multi-terabyte RAC architecture
• Unix/Linux shell scripting
• Retire Legacy data- modifying Oracle objects
• Interacting with various team and business analysts
• SQL tuning(OEM), query optimization
• Materialized-views, Partitioning, Live-mirror table flipping
• TOAD, SQL Developer.
• VMS Mainframe to Linux upgrade, Autosys scheduler
• Oracle security, roles, privileges
• On-call application support.

Oracle DBA

Confidential, St. Louis, MO

Responsibilities:

• Oracle 9i/10g RAC, MC Service Guard
• Oracle 10g ASM
• Shell Scripting-Server Startup-shutdown scripts.
• Documentation and coordinating with Unix SA for server maintenance windows.

Oracle DBA

Confidential, St.Louis, MO & Chicago, IL

Responsibilities:

• Recommend performance related enhancements
• SQL Optimization, tuning queries
• Worked both on Production and Test databases.
• Fragmentation, chaining cleanup
• Tablespace migration to Locally managed tablespaces
• Oracle 9i, software bugs, Patches
• Modified analyze jobs for performance
• Database level-Init parameters evaluation
• Miscellaneous on-going DBA activities.

Environment: WinNT/2000/XP, Oracle 9i, OEM, SunOS 5.8(Cluster), TOAD.

Oracle DBA

Confidential, St.Louis, MO

Responsibilities:

• Exposure to Latest Version of the software, Upgraded oracle 8.1.6 to 8.1.7, oracle 8.1.7 to 9.2.3, software bugs, Patches
• Data load through Infomover and not FAT files from mainframe.
• Automated jobs through Autosys
• UNIX Shell/SQL scripting, PL/SQL coding.
• SQL Loader-Direct/conventional performance, Parallel Loads, identifying rejected data, export-import.
• Large Partition/Subpartition history tables upto 60 months history.
• Used tools like SQL-Station, ERwin, OEM, Desktop DBA.
• Monthly database changes, data loads, Implementation Plans.
• Resolving issues to accomplish successful UAT(User Acceptance Testing).
• Mainframe jobs, SQL Loader/Par files, Cobol/Oracle copybooks.
• Analyze, rebuilding indexes for History tables, load statistics.
• Logical/Physical Datamodeling, ERwin “complete compares”, sync up with the data marts after monthly installations, validating entire schema.
• Friendly, yet professional interaction with the application team.
• Many more DBA activities.

Environment: WinNT/2000/XP, Oracle 8.1.6/ 8.1.7/9.2.3 , HP-UX V-class, Reflection, Mainframe COBOL, SQL-Station 6, Desktop DBA, OEM 6.0, ERwin 3.5.2, Allfusion ERwin Datamodeler 4.0, Lotus Notes.

Oracle DBA

Confidential, St.Louis, MO

Responsibilities:

• Moving Schemas,copying data from old tables
• Establishing Database links, checking TNSNAMES, User connectivity.
• Reviewing User privileges and session roles.
• Export-Import and UNIX Cronjob
• Reviewing the entire database schema.
• Many more DBA activities.

Environment: Oracle 8i, Confidential AIX, SUN OS 5.6,E4000,Sparc20, Exceed, TOAD and ERwin.

Oracle DBA

Confidential, Chicago

Responsibilities:

• E-commerce project for Motorola Online.
• Also EMEA(Europe Middle East and Africa) support, analyzing errors for remote databases as the project is worked out only in US.
• Responsibilities included creating Back-end tables, Data modeling using Erwin
• ORACLE TAR and 8.1.6.2 patch implementation.
• Export-Import and database links between production and test databases.
• Perl jobs and Cronjob
• Index optimization and SQL hints.
• Schema creation including triggers, constraints, sequences, tables, indexes
• In the process Migrating the instance to a new server before going live.
• Reviewing the entire database schema.
• Back-end Oracle stored procedures and optimizing SQL code for VB-ASP,
• Many more DBA activities.

Environment: Oracle 8.0.5, Oracle 8.1.6(8i), Confidential AIX, HP-UX 11.0, Exceed, TOAD and ERwin.

Oracle DBA

Confidential, MO

Responsibilities:

• Managing all the instances including production and development.
• Starting/stopping Concurrent Manager in Oracle financials.
• Recovery from hot backup and cold backup.
• Databases overlay, updating QA databases to reflect the production data.
• Familiar with HP-UX, EMC-Array and disk mirroring.
• Creating test databases and deleting old instances.
• Importing and exporting data in the event of accidental table dropping on dev instances.
• Implementing Oracle patches and database installations.
• Listener and TNS Names configuration and maintenance.
• Creating and assigning tablespaces, profiles, roles, privileges.
• Managing rollback segments and redolog files.
• Assist developers in creating SQL queries for optimum performance.

Environment: Oracle 7.3.4.3 server, HP-UX 11.0, EMC-Array(disk mirroring), OEM, Toad.