SUMMARY:

• Accomplished Oracle, SQL server and PostgreSQL Databases Specialist: experienced database administrator, data modeler, SQL and PL/SQL developer.
• Experience with Oracle9i, 10g, SQL server 2005/2008 and PostgreSQL9.1 under Unix and Windows, in production support and development environments.
• Strong knowledge of database performance tuning, monitoring, database backup and recovery, installation, configuration, upgrading and patching of Oracle software and databases, data modeling.
• Self - starter and quick learner with excellent analytical, problem solving and communications skills.
• Ability to work as a team member and as an individual contributor.

TECHNICAL SKILLS:

• VB.net, ASP.net, Microsoft visio 2010, MS Active directory, MS Windows XP, MS windows 7
• Dreamweaver, EMS SQL Management Studio, SQL, MySQL, PostGreSQL, SQL Server 2008
• Java, PHP, C++, Delphi, Crystal reports, Ireports
• MS outlook, MS office Tools (MS access, MS word, MS excel, MS PowerPoint, MS publisher )

PROFESSIONAL EXPERIENCE:

Confidential, Sioux City, Iowa

Database Developer / Administrator

Responsibilities:

• Application Project “Long Distance call billing” using Vb.net, ASP.net, MS visio 2010, Oracle 10g, Crystal reports 2010,
• Application project “address book” using Vb.net, ASP.net, MS visio 2010, SQL Server 2008, Crystal reports 2010,
• Application Project “Loan calculation” using PostGreSQL, Vb.net, ASP.net, MS visio 2010, ireport,
• Create and administer a Postgres Database using pgAdmin 4.1
• Created SQL queries for diverse usage; ensured integrity of data with frequent restoration and back up using pgAdmin 4.1, PostGreSQL.

Environment: .net, SQL Server 2008, Crystal reports, MS vision 2010, PostGreSQL, Oracle 10g

Confidential, South Sioux City, NE

Responsibilities:

• Migrate Confidential IT equipment, user accounts, and exchange accounts to the Confidential domain.

Confidential

Database Developer / Administrator

Responsibilities:

• Designed, created and managed database using MS Visio 2010.
• Create and administer a Postgres Database using pgAdmin 4.1
• Development and manage a Postgres Database using PL/pgSQL
• Install, configure, maintain and administer Linux Debian operating system
• Install and configure the MediaAgent - AIX, HP-UX, Firewall.
• Migrate PostgreSQL 8.4 database to PostGreSQL 9.1 database using pg dump and pg dumpall,
• Migrate Oracle 9i database to PostGreSQL 9.1 database using ESF Database migration toolkit.
• Created SQL queries for diverse usage; ensured integrity of data with frequent restoration and back up using pgAdmin 4.1, PostGreSQL.
• Performed Data Gap Analysis in current data warehouse,
• Assisted with project and problem analysis, effectively communicate with management and adhere to Bank’s policies and procedures.
• Developer and administrator of Socio-economic application using PostGreSQL, PHP, Java, HTML, XML, pgAdmin 4.1, ireport.
• Developer of Human resource application using Oracle 10g, PHP, Java, HTML, XML, Crystal reports 2008
• Extract, Transform and load data in distant databases using Informatica PowerCenter and SQL Server Integration Services.
• Developer of electrical equipment database of SONABEL Energy company using Perl & Bash Scripting, PostGreSQL 9.1,
• Developer of training and improvement competencies database of SONABEL Energy Company using Perl & Bash Scripting, PostGreSQL 9.1,
• Developer and administrator of Geographic Information System application using ARCGIS 9.1, Vb.net, ASP.net, ARCVIEW, SQL Server, EMS SQL Management Studio
• Database design and modulation Environmental management using MS visio 2010, PostGreSQL.

Environment: Oracle 10g, .net, vba, PostGreSQL, Ireport, php / java, ARCGIS 9.1, Google Map, ARCVIEW, SQL server 2008, EMS SQL Management Studio, pgAdmin 4.1, MS visio 2010, Perl & Bash Scripting.

Confidential

Programmer analyst

Responsibilities:

• Create and develop database using pgAdmin 4.1;
• Create and develop Geographic information system (GIS) using Postgres Database, VB.net, ASP.net, ARCGIS 9.1, 2005,
• GIS database administrator using PostGreSQL, pgAdmin 4.1,
• Application program “System Information Foncier” using PostGreSQL, pgAdmin 4.1, VB.net, ASP.net, ArcView 3.2a, Google Map, Crystal reports
• Application program “Management system of electric equipment” using Oracle 9i, VB.net, ASP.net, ArcView 3.2a, Google Map, Crystal reports.

Environment: Oracle 9i, .net, ARVIEW 9.1, ArcView 3.2a, vba, Google Map, Vb6, Vba, Suite Microsoft office.