Oracle Sql
Resume:
NIRMAL K. GHOSH
*** ****** *** *** ***, Silver Spring, MD 20910 • 301-***-**** • ******.*****@*****.***
ACTIVE TOP SCRET CLEARNCE FROM 2010
SKILLS SUMMARY:
A Senior Data Specialist with more than 15 years using SQL and 4 years PL/SQL /DBA experience
and Oracle tools. I have a proven ability to analyze processes, functions, procedures and clearly report
their impact on operations and logistics. In addition, I have extensive experience in computer
programming, developing commercial software and scheduling operations.
CORE COMPETENCIES
• Oracle, SQL, PL/SQL • Oracle DBA • TOAD
• UNIX /LINUX • Data Modeling • ORACLE FORMS
• ORACLE REPORTS • Microsoft Office • HTML
• Shell Scripting • MS SQL
HIGHLIGHTED CAREER TRAINNING
Learning Tree International
Rockville MD
Oracle PL/SQL Hands On Training
DBA University
Chicago (On Line)
Oracle DBA Hands On Training
University of Maryland University College
College Park, Maryland
Database Management Certification
PROFESSIONAL EXPERIENCE
Syneren Tech Corporation (US Navy) Nov 2013 Present
Database Engineer
• Developed and performed test plans.
• Wrote PL/SQL scripts to manipulate data and generate tables.
Nirmal K. Ghosh
Senior Programmer Analyst
• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and
exception handlers as well as procedures and functions.
• ORACLE database server software installation.
• Database Creation .
• Database configuration assistant (DBCA).
• Managing tablespaces and datafiles.
• Managing Database users, privileges and role authorization.
• Managing online redo log files and archivelog mode.
• Administrated the existing databases, monitored the database performance.
• Oracle Job Scheduling.
• Oracle database cloning (Using Hot Backup).
• Oracle Database Cloning (Using RMAN Backup)
• Oracle Data Movement (Data Pump Export and Data Pump Import)
• Performance Tuning, Tracking database sessions.
• SQL Statement execution Plan (Explain Plan) and Optimizer Statistics.
• Oracle 12c R1 Database Software Installation.
• 12c R1 Database Creation USING DBCA (Non-Container Database)
• Converting A Non-CDB into a pluggable database(PDB)
• Work experience in AGILE and Waterfall methodologies.
• Ut ilized the Web logic interface to monitor reports/forms usage.
• Ut ilized load (Oracle SQL Loader utili ty) process to upload Financial Accounting
data.
HARRIS IT Services (US Navy NRL)
Software Engineer Nov 2012 – October 2013
• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and exception
handlers as well as procedures and functions.
• Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup.
• Database L inks, Creating and Managing Table spaces and Data files, Creating and
Rebuilding Indexes, Managing Database Security.
• Creating Database users and granting roles.
• Handling Import/Export like schema, table, full database etc.
• Troubleshooting and maintenance of Oracle Database.
Nirmal K. Ghosh
Senior Programmer Analyst
• Handling space issues.
• Attend daily change requests for production database.
• Responsible for developing and maintaining client server and web based application
by using Oracle Forms and Reports.
• SQL Statement execution Plan (Explain Plan) and Optimizer Statistics.
• Moved data between databases and external files using SQL Loader for the bi-weekly
O H Budget and Financial Cost Accounting.
• Wrote PL/SQL scripts to manipulate data and generate tables.
• U tilized the Web logic interface to monitor reports/forms usage.
• U tilized load (Oracle SQL Loader utili ty) process to upload Financial Accounting
data.
General Dynamics IT (US Army) 2002 – Oct 2012
Programmer Analyst
• Developed, maintain, schedule and monitor ETL process.
• ORACLE database server software installation.
• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and
exception handlers and wrote procedures and functions.
• Responsible for the review, evaluation and determination of usability of data
contained in the multiple Oracle databases.
• Composed Oracle SQL and PL/SQL of stored procedures, triggers, functions,
packages 10g/11g.
• Developed excellent analytical skills.
• Gained experience with Performance Tuning (Database).
• SQL Statement execution Plan (Explain Plan) and Optimizer Statistics.
• Skilled in Tuning of PL/SQL code using Index, and Hints etc.
• Experienced in working with Linux Operations environment and Windows
Development environment
• Responsible for the review, evaluation and determination of usability of data
contained in the multiple Oracle databases.
• Produced products that serve the more than 320,000 globally dispersed
customers reporting to the15 Regional Personnel Offices.
• Used ODBC drivers to transfer files from an ORACLE database into a Microsoft
Access database
• FTP’d large volumes of data using SQL-LOADER and TOAD to transfer the files
from the MS Access environment into an ORACLE database residing on an HP
UNIX server.
• Repository extensively and designed, and implemented a new universe to
support the user requirements.
• Wrote SQL/PLSQL scripts to generated outputs for user
Nirmal K. Ghosh
Senior Programmer Analyst
• Conducted daily, weekly, and monthly database loads from input sources.
• Supported monthly, quarterly, and annual reports and extract files generation.
• Maintained the development and production database
• Provided full-scale Technical support to users
• Generated daily, monthly, quarterly and yearly reports
• Provided full-scale Technical support to users
• Provide full-scale support to UNIX/LINUX operations.
• Performed the database maintenance & administration activities
• Troubleshot all database problems associated with the loading of data into
tables
• Coordinated with system administrator for maintenance and tuning of hardware
• Administrated the existing databases, monitored the database performance
• Wrote SQL/PLSQL scripts for database activity monitoring
• Documented the existing application systems
• Conducted regular backup of the database
• Maintained large volume database
2000 – 2002
FC Business Systems (US Army)
Production Support Specialist
• Was responsible for large scale initial review, evaluation and determination of usability of data
• Used ODBC driver to transfer files from ORACLE database to Microsoft access database
• FTP’d large volume data from MAINFRAME to UNIX, used SQL LOADER to transfer files
from UNIX to ORACLE database.
• Wrote SQL and PL/SQL to create reports and moved reports to Microsoft access database and
excel spreadsheets. My specific responsibilities include
• Used Business Object Universe, Business Objects Reports and Business Objects repository
extensively and designed, and implemented a new universe to support the user requirements.
• Support monthly, quarterly, and annual reports and extract files generation.
• Maintain development and production database.
• Provide full scale Technical support to users.
• Performed the database maintenance & administration activities.
• Troubleshot all database problems associated with the loading of data into tables.
• Coordinated with system administrator for maintenance and tuning of hardware.
• Administrated the existing databases, monitored the database performance.
• Wrote SQL/PLSQL scripts for database activity monitoring
Network Specialty Group Inc – Oracle Application Developer 1995– 1999
• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and exception handlers
• Wrote procedures and functions, as well as used Oracle Forms 5.0 and Oracle Reports 3.0 to
accomplish these tasks
Nirmal K. Ghosh
Senior Programmer Analyst
• Gave presentations on projects development progress
• Provided end user support in the form of formal training and telephonic support
EDUCATION
Bachelor of Science in Accounting, University of Calcutta, India 1984
Contact this candidate