Uploaded File
add photo
Prabin
pbaniya04@gmail.com
402-637-3829
Omaha, NE 68198
Oracle DBA /Developer
16 years experience W2
0
Recommendations
Average rating
14
Profile views
Summary

Exceptionally well organized and resourceful professional with more than 16 years' experience in programming, Database Design and Administration excellent analytical and problem solving skills able to handle multiple projects while producing high quality work in a fast-paced, deadline-oriented environment. SKILL Languages: ClASS, VXML, C++, C#, HTML, XML, Java, SQL, ORACLE SQL, PL/SQL, COBOL, FORTRAN, PERL, PHP.

Experience
Information Technology
Oct 2016 - present
DevOps
  • Install, configure, upgrade, and patch and tune Attunity Replicate and Attunity Enterprise Manager Tool.
  • Migrate on promise Attunity Replicate Servers and Databases to Azure Cloud.
  • Setup and design new data replication task.
  • Tune and maintain existing data replication task.
  • Develop packages, procedures, functions, and triggers.
  • Actively participate in change request and change control procedures of an organization.
  • Tune SQL Query and provide tuning recommendation to long running jobs and queries.
  • Use Explain plan, Index Hints and creation of new Indexes to improve the performance of SQ statements.
  • Performing the tests on the newly coded procedures and documenting the code.
  • Automate jobs and repetitive Database Administration tasks.
  • Write PL/SQL code using the technical and functional specifications.
  • Reorganized databases and sized database objects to meet standard and improve performance.
  • Assisted developers in query tuning and problem resolution.
  • Serve on-call attending to problems and resolving database-related issues and requests.
No skills were added
Remove Skill
Oracle DBA /Developer
Information Technology
Nov 2015 - Oct 2016
  • Develop packages, procedures, functions, and triggers.
  • Actively participate in change request and change control procedures of an organization.
  • Tune SQL Query and provide tuning recommendation to long running jobs and queries.
  • Use Explain plan, Index Hints and creation of new Indexes to improve the performance of SQ statements.
  • Create Linux Server to Install Oracle Database on Oracle VM box for testing and designing
  • Performing the tests on the newly coded procedures and documenting the code
  • Automate jobs and repetitive Database Administration tasks.
  • Write PL/SQL code using the technical and functional specifications.
  • Reorganized databases and sized database objects to meet standard and improve performance.
  • Upgraded Oracle Virtual box to latest version.
  • Installed Oracle12c Instance on VM box for development testing and training
  • Assisted developers in query tuning and problem resolution.
DBA Oracle SQL Triggers
Remove Skill
SQL Server DBA
Information Technology
Jul 2014 - Nov 2015
  • Routinely refresh the QA environment for UAT before applying change on the production database environment
  • Administered SQL Server 2008R2 and 2012
  • Moved applications database data to the data warehouse
  • Actively participate in change request and change control procedures of an organization
  • Tune SQL Query and provide tuning recommendation to SQL Jobs, long-running SQL queries, CPU/time consuming queries.
  • Use Explain plan, Index Hints and creation of new Indexes to improve the performance of SQL statements
  • Provide tuning recommendations to DBA manager to make changes in database like table partitions, data clean up, data compression, purge, archive, space requirement.
  • Design and create different indexes in a table to optimize the performance and tuning
  • Resolve performance tuning related issues and queries and perform root cause analysis on failure.
  • Use SQL Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and databases
  • Implement Functions, Triggers and Stored Procedures and enforce business rules via database constraints
  • Create Schemas, Users, Profiles, Roles, Privileges, Table/Index/ Rollback, Segments, and Constraints
  • Run DBCC consistency checks and fixing data corruption in application databases.
  • Extract and transform data using ETL Import/Export data, Bulk Insert, BCP utility and SSIS packages
  • Serve on-call attending to problems and resolving database-related issues and requests.
DBA ETL Performance Tuning SQL SQL Server SSIS Stored Procedure Triggers
Remove Skill
Oracle DBA
Information Technology
Oct 2012 - Jul 2014
Columbia, MO
  • Support Development, Test, and Production Databases to 40+ databases on fifteen different servers with 40TB in size
  • Managed security by creating Schemas, Users, Profiles, Roles, Privileges, Table/Index/ Rollback, Segments, and Constraints
  • Spent 80% of time moving data from the applications database to the data warehouse
  • Setup, monitored, troubleshot, and supported Oracle Streams (Capture, Propagate, and Apply) and Advanced Queue (AQ) Framework environment.
  • Tuned and optimized current and new applications using SQL Trace utility and DBMS packages
  • Enhanced performance through regeneration/rebuild of indexes and creation of views or materialized views using synonym dance
  • Increased performance of the databases and saved the space of the database through Partition and Advanced Compression.
  • Provided assistance in logical/physical data modeling to ensure entity-types are in sync.
  • Performed various database administration duties using advanced querying protocols and PL/SQL scripting techniques
  • Used various IDE tools like SQL Developer, Toad, SQLPLus
  • Designed and configured connectivity between the web applications and Oracle database including scripting of pool creation and troubleshooting problems
  • Served on-call attending to problems and resolving database-related issues and requests
Data Modeling DBA Oracle SQL SQL Developer
Remove Skill
Oracle Developer
Information Technology
Jan 2007 - Oct 2012
Omaha, NE
Oracle
Remove Skill
Technical Support Analyst
Information Technology
Jan 2005 - Jan 2007
Omaha, NE
  • Provided first tier technical support for back office software and POS systems by troubleshooting hardware, software, network connectivity issues and installations
  • Setup and supported customer workstations working with ORACLE database tables and prepare corporate report
  • Developed Intranet to provide corporate employee information and controls inventory of the warehouse
  • Installed and upgraded Oracle Database Server and other tools
  • Created primary objects including tables, views, indexes and constraints stored procedures, functions, triggers and sequences
  • Enrolled users, assigned roles and maintained database security
  • Backed up and restored database and instances modified database structures.
  • Provided end user support to local and remote Oracle developers.
Oracle Stored Procedure Triggers
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Information Systems
Bellevue University 2013
Computer Science
University of Nebraska-Lincoln 2004
Metropolitan Community College
Certifications
ORACLE Database System Certificate
Skills
Oracle
2016
10
DBA
2016
4
SQL
2016
4
Triggers
2016
4
Stored Procedure
2015
3
Data Modeling
2014
2
SQL Developer
2014
2
ETL
2015
1
Performance Tuning
2015
1
SQL Server
2015
1
SSIS
2015
1