We provide IT Staff Augmentation Services!

Security Tools Administrator Resume

Albany, NY

SKILLS SUMMARY:

  • Oracle PL/SQL 6+ 2014
  • Sybase 9+ 2014
  • MS SQLServer 15 2006
  • DB2 1 2008
  • Postgresql 5 2016
  • MySQl 1 2013
  • Unix Script 8+ Current
  • DOS/Windows/Basic Script 10+ 2008
  • Cobol 3 1990
  • C,C++,C# 2 2002
  • VB/VBA 5 2003
  • ASP.Net 1 2003
  • Java 3 2016
  • JavaScript 1 2004
  • AbInitio(ETL) 3 2008
  • Sunopsis(ETL) 4 2014
  • Sybase Replication (ETL) 5 2014
  • Informatica(ETL) 1 2007
  • Talend 1 2016
  • Windows NT/2000/XP Network Admin 4 2002
  • Business Objects 1 2007
  • Cognos 1 2008
  • MVS/TSO 6 2008
  • CVS 5 2016
  • SVN 2 2106
  • MS VCS 2 2003
  • LogRhythm 3+ current

WORK HISTORY:

Security Tools Administrator

Confidential, Albany, NY

Responsibilities:

  • Worked along side Operations and Security Teams to stabilize their current LogRhythm SIEM platform.
  • SQLServer was utilized as the database supporting the SIEM.
  • I upgraded platform( Windows 2000 to 2016 and SQLServer2012 to SQLServer2016) and enhanced the security monitoring to meet the Confidential needs.
  • Having DBA experience was necessary to support maintenance and researching issues and we had many occasion to utilize my knowledge of transaction logging to resolve system and performance issues.
  • And I did utilize my skills to support maintenance and researching issues.
  • I did have many occasions to utilize my knowledge of transaction logging when issues occurred.

Database Developer

Confidential, Saratoga, NY

Responsibilities:

  • Installed and tuned Postgres database.
  • Migrated DB2 procedures to Postgres.
  • Worked with Development team to remove some processing in Java to procedures to bring nightly processing from over 24 hrs to 2 hrs.
  • Developed model VMs for customer installations and began migrating customers to Postgres platform.

DataAnalyst

Confidential, St, Albany, NY

Responsibilities:

  • Extracted Data From Oracle database(s) for graphical input to web pages for clients.

Database Developer

Confidential, Queensbury, NY

Responsibilities:

  • Position required developing and maintaining many procedures ( T - SQL and PL/SQL) for Sybase and Oracle in addition to many triggers and functions.
  • Responsible for replication/transformation from Sybase to Oracle/AWS and Postgres environments using Sybase replication and custom procedures.
  • Developed and maintained several java applications in conjunction with HTML to support some of our monitoring tools.
  • Used UNIX shell and perl scripts in combination with PL/SQL, crontab for some database maintenance( update statistics, DBCC checks,ANALYZE and DBMS STATS) and preventative alerts.
  • Performance monitoring and tuning of Sybase and Postgres environment.
  • Provided rotational oncall support for all database activities.
  • Reviewed and recommended design standards for all database design.
  • Often tuned queries for myself, application developers,and team members using query plans, cached plans, etc for increased efficiencies.

Lead Applications Developer

Confidential, Albany, NY

Responsibilities:

  • I migrated Unix scripts from SunSolaris to Linux RedHat as well as coding several new Sybase procedures and refactoring existing PL/SQL procedures.
  • Several new applications in Java were required, all to support the merge.
  • We upgraded Oracle from 8 to 9i and converted their SQLserver apps into Oracle.
  • Many new applications in Java were necessary and a new Oracle schema were architected to support a Data repository for regulatory reporting.
  • There were several customized MS Access data feeds we supported from the Oracle data warehouse .
  • I then joined their Risk and Compliance department developing Anti-Money Laundering systems for Fraud Detection that utilizes an Oracle 9i/linux application with Java and Informatica interfaces. AbInitio is used to extract data required for money-laundering analysis from the legacy mainframe data repositories.
  • I converted from Business Objects to Cognos all reporting.
  • After the merge, we reviewed and redesigned our MSSQL databases that supported our web faces to assure it accommodated all our new business.

Contracted Programmer

Confidential, Albany, NY

Responsibilities:

  • Unix and Oracle Database developer for Confidential .
  • Developed Testing Utilities using Unix script, PL/SQL,HTML,Java and implemented upgraded Claims processing system.

Programmer

Confidential, Albany, NY

Responsibilities:

  • Developed Fraud datacapture system with Domino Forms frontend and converted Access
  • DataBase to Oracle Database. Reviewed and designed PL/SQL procedures to audit data transformation maintained for their International Leasing System.

Hire Now