Database Developer / Administrator Resume
2.00/5 (Submit Your Rating)
Sioux City, IowA
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.