Skills

Employment History

Confidential

Database Administrator

Core Responsibilities:

• Currently handling responsibility of Oracle DBA and onsite coordinator
• Handled responsibility of Project Manager for 2 years

Current Responsibilities

• Onsite Oracle DBA and coordinating Oracle DBA team of 45 working from offshore and supporting 2000 oracle databases
• End of End database primary System DBA support
• Responsible for 24 7 Database support includes on-call DBA support
• Trouble Management and Change Management using BMC Remedy Tool
• Planning and implementing database changes including CPU patches, database upgrades
• Implementing corporate database security and resolving security vulnerabilities
• Implementing database backup and recoveries when needed
• Database migrations during server lease roll over or platform changes
• Database transitions and customer coordination for DBA services
• SLA monitoring for project
• Provide storage estimate to the Centralized DBA, System Administrator, and Storage Management Group for capacity planning
• Interface with the Application DBA and Development communities
• Provide a second-line resource for DBMS-related assistance to Application DBAs.
• DBMS software installation upgrades and patch-sets.
• Consult, configure, and manage DBMS special features, such as Replication, Parallel Server, Standby
• Database and/or tablespace creation, upgrade, migration and management
• Monitor Database performance

Technical Expertise

• 24 Primary DBA and on-call support
• Oracle DBMS software installation, upgrades and patch-sets
• Golden Gate software installation and maintenance. Helping application team to setup replication processes
• Backup and recovery using RMAN and user managed backup
• Performance Tuning I/O, Memory SQL Tuning etc by using tools/utilities by Automated Workload Repository AWR , Automatic Database Diagnostics Monitor ADDM .
• maintaining Oracle Data Guard Standby Database and providing critical Solution with strategic disaster recovery plans with different recovery procedures and methods
• Hands on experience with various tools like SQL Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager OEM .
• Monitor the DBMS system events/alerts using tools like MBC Patrol and Remedy
• Perform Memory allocating tuning ex. SGA, DB Block Buffers, etc.
• Perform system-wide DBMS I/O tuning evaluate SAR output, hot disk reorganizing datafiles across disks, consult with Application DBA for table reorganizations
• Perform system-wide tuning as needed to manage long-running DBMS tasks OLTP vs. Batch .
• Utilize standard scripts to do all DBA functions
• Provide table level exports and imports per application written guidelines.
• Perform table level I/O tuning, consulting with the Centralized DBA
• Work with database designers and system analysts to ensure optimal normalization
• Modification of logical database structure as required by application planners and developers
• Identify DDL creation responsibility
• Coordinate DBMS failover environments as required

Confidential

Core Responsibilities:

• Worked for 3 different projects during the period
• PL/SQL coding, Oracle Database Administration, project coordination

Technical Expertise

• Data Modeling, Manage the logical database design, Optimize application SQL
• Work with programmers to optimize application SQL
• Manage all application batch processes includes all exports and imports
• Perform Database and User Access
• Control access to Application data within the DBMS including passwords
• Control and monitor user access to the database
• Control user privileges within a database
• Enroll non-DBA users
• Planning and implementation of security, users access and privileges for database objects/application data includes Enroll non-DBA users
• Determine and enforce naming conventions for objects visible to applications
• Manage application object names for the scripts so they can be backed up by oracle tools such as export.
• Assist and review application-specific design considerations
• Work with application to determine data retention requirements and review/ensure reliable data archiving processes/schemes
• Assist applications in managing the database data, such as developing the purge job.
• Manage all client tools to access database includes Oracle client front end and networking tools
• Provide scripts to runs as well as back out scripts to Centralized DBA
• Troubleshooting scripts or problems created by incorrect scripts

Confidential

Database Developer/Implementation Lead

Core Responsibilities

• DBA support for product customers to install, maintain and tune banking products
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using ERwin.
• Developed ER Diagrams and Dataflow Diagrams with Business Analysts.
• Developed the databases, Tables, Views, materialized views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL
• Generating the reports for the executives as per the requests.
• Work closely with the developers and DBAs' on the code tuning for the reports.
• Loading the data from flat files using the SQL Loader
• Monitoring the backup plan and managed Import/ Export data for Dev and QA team.
• Managing development and test databases during product development life cycle includes creating and cloning databases for trouble shooting.
• Customizing product based on customer requirements. Requirement analysis, design and development to support new implementations. Production application support for all the customers
• Developing client specific enhancement and implementing support requests. Product customizing and managing the product delivery. Change and configuration management

Technical Expertise

• Installation, Configuration, Upgrade and patching of Oracle 9i/10g.
• Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Provided support to Application Database Administrators in designing the database.
• Scheduling and Performing regular database backups using RMAN.
• Using sql trace, tkprof, explain plan, autotrace, statspack reports for performance issues resolution.
• Extracting of data from different flat files into Oracle Database using SQL Loader and automated the process.
• Import and Export of database objects to copy from one database to another database.
• Responsible for creating Database links.
• Developed UNIX Shell Scripts for automating the loading procedures.
• Upgraded Oracle 9i databases to Oracle 10g and implemented Oracle 10g features to ensure high performance and easy maintenance.
• Automating the regular processes using Dbms scheduler, Crontab job schedulers.
• Creating users and roles to maintaining database security.
• Worked with application developers to debug PL/SQL programs, tune queries and database sizing.
• Creating PL/SQL packages, procedures and database triggers.
• Database tuning, backup and recovery and general day to day running of the system.
• Systems analysis and design.
• Provided on-call support for Production databases and also resolved the issues working with development team.

Confidential

Systems Officer

Core Responsibilities

• Program ERP software using Oracle PL/SQL, Forms and Reports.
• Design and development of Tables and stored procedures for the ERP system.
• Analyze the business logics of the ERP software and built Business Layer.
• Component based design to enable independent use of each module.

Technical Expertise

• Data Modeling, Manage the logical database design
• Optimize application SQL, Work with programmers to optimize application SQL
• Manage all application batch processes includes all exports and imports
• Source and Downstream Data Management
• Application stored procedures, functions.
• Perform Database and User Access, Control access to Application data within the DBMS including passwords, Control and monitor user access to the database, Control user privileges within a database, Enroll non-DBA users
• Planning and implementation of security, users access and privileges for database objects/application data Determine and enforce naming conventions for objects visible to applications
• Manage application object names for the scripts so they can be backed up by oracle tools such as export.
• Assist and review application-specific design considerations

Confidential

Software Professional

Core Responsibilities

• Analyzing existing processes followed by customer. Interviewing application users and requirement gathering. Preparing logical model and finalize physical model.
• Design, Develop and build application component like database schema, procedures, functions and packages. Design, Develop and build application forms and reports.
• Prepare unit test cases, system test cases and test result