SUMMARY

• Seeking a leadership position with the opportunity to lead system testing and implementation to improve productivity and performance. Client - focused and dedicated to user support and customer satisfaction.
• Hands on experience in all stages of Software Development Life Cycle (SDLC)
• Strong command on UNIX, C++, C program.
• Completed projects using Java, Apache Tomcat server, JDBC, JavaScript, and XML, SQL.
• Hands on experience in developing searching techniques and searching algorithms and on security systems - Authentication LDAP server.
• Experience in writing SQL, PL/SQL queries, Stored Procedures for accessing and managing databases such as Oracle 11g/10g, SQL Server 2012
• 4+ years experience on high-volume transactional systems running on Unix/Linux and Windows
• Involved in app design providing suggestions to the team, providing new ideas.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Experience in database programming inPL/SQL(Stored Procedures, Triggers and Packages).
• Strong experience in Data Warehousing and ETL usingInformatica Power center.
• Used SQL Loader to move data from SQL environment to Oracle environment.
• Extensive 4+ years experience in working on multiple operating systems including UNIX, Linux and Microsoft Windows.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center. well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Experienced in business/technical requirements capturing, configuration management, team coordination and software engineering processes.

TECHNICAL SKILLS

Languages: Java 5, Unix, HTML- CSS, JavaScript, XML, SQL

Software: JDBC 2.0, Oracle, MySQL, LDAP, Identity Access Management

Database: Oracle 10g/11g, Microsoft SQL Server 2008

Tools: PL/SQL, SQL, SQL * Plus, OpenDJ, OpenIDM

Design: UML, E-R Modeling

Operating Systems: Windows 2000/XP/Vista/7, Linux, Unix

PROFESSIONAL EXPERIENCE

Oracle/Teradata DBA

Confidential, TX

Responsibilities:

• Administration of Oracle DataWarehouse and movement of data and structures from Oracle to Teradata. Modification and maintenance of Materialized views in oracle. As Oracle Data warehouse DBA carried out Backup and Recovery, Performance tuning and enforced security procedures for new users.
• As Teradata DBA carried out promotion of structures and data through to production environment, stats gathering and scheduling of stats. Created databases/users, and carried out performance tuning, backup and recovery.
• Responsible for execution of RAC DB environment management, support/maintenance and development activities - backup/recovery, performance tuning, cloning databases/schemas, collecting stats, physical database design, database environment configuration.
• Built standard Database Server, patched it to current version and created skeleton database rolling out stats pack, object stats collection and RMAN backups. Monitored and tuned expensive SQL using Oracle Grid control.
• Used oracle streams to move 1.3 Tb data from Oracle 9i to 10G effectively upgrading the environment. Cloned production database for development use and scrubbed sensitive information. Worked with development team to implement the latest application upgrades and patches.
• Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application of patches.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.

Information Analyst

Confidential

Responsibilities:

• Duties including monitoring server performance of the DataWarehouse (W/H) using Sybase ASE 11.5 Server on Aix Unix, ensuring that server configurations would maximize performance. Allocated space, controlled access and ensured backups were performed.
• As Business Objects/Data Warehouse Administrator, designed data marts-setting up the various objects and joins both inter and intra data marts.
• As transact-sql developer wrote stored procedures and cursors for reporting purposes.

Oracle DBA-Intern

Confidential

Responsibilities:

• Held Oracle DBA responsibility for parallel Oracle/SAP database using Oracle Parallel Server.
• Created Oracle 8i databases for 2 large departments, from planning and testing through production.
• Created database reorganization procedures, scripted database alerts, and monitored scripts.
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Enhanced MS-Access databases by improving user interface, introducing multiple-user access, and increasing security and stability.
• Responsible for Oracle 9i logical and physical database design, implementation, and maintenance.
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.

SQL- DBA

Confidential

Responsibilities:

• Writing Test Plan, Test Scenarios, Test Cases and Test Matrix documents analyzing the Use Cases. Responsible for manually testing the entire application for GUI, Functionality, Business Logic and Use case adherence.
• Writing Automated Test Cases, Test Scripts, and Testing Scenarios, using Quick Test Professional for Regression testing, implementing the required checkpoints and updating them from time to time.
• Utilized SQL and PL/SQL for working with data relating to testing, test dataset creation and verification.
• Analyzing key scenarios to realize crucial functional areas of the application, Creation and Execution of QTP Test Scripts against the Key functional areas and Performance Testing of the Application
• Defect reporting, tracking and generation of reports and graphs for management requirements.