Database Architect Resume New York, NY - Hire IT People

SUMMARY:

Technically sophisticated database administrator, infrastructure automation engineer, with solid history of managing mission critical databases in a highly scalable environment.
2 years of working with Postgres as a Database Architect and developer.
4 years of managing DB2 LUW for mission critical applications.
Familiarity with Cassandra
Over 8 years of database infrastructure development work in Perl, C, Python to support infrastructure of RDBMS in a highly available and distributed environment.

TECHNICAL SKILLS:

Databases: Postgres 9.5, DB2 LUW(10.5), SQL Server (2008), Cassandra 2.2 / 3.0.3

Languages: Perl, Python, SQL, C

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Database Architect

Responsibilities:

Designing the physical schema of the ongoing new project using Postgres.
Working with the developers in writing optimized queries.
Writing data validation tools in Python + Postgres.
Writing tools for the infrastructure testing of the high availability of the Postgres database clusters.
Successfully completed POC of Cassandra for usage as an event store.
Working with the application team in the Data modeling of the Cassandra event store.
Working with the infrastructure team in developing Cassandra monitoring scripts in Python.

Confidential

DB2 Database Administrator and Team Lead

Responsibilities:

Designed and developed high availability solutions for DB2 using HADR and QREP in Perl.
Designed custom monitoring solutions for high - availability in Perl.
Designed, developed and implemented DB2 metrics capture system for application performance analysis in Python and integrated it with Splunk.
Evangelized the DB2 technology within the application groups like columnar storage technology (BLU).
Wrote data comparison tool in Perl for validating data between two replicated databases.
Provided on call support during off business hours.
Upgraded DB2 servers.
Migrated DB2 servers with zero downtime from Solaris/AIX to Linux.
Work with the vendor ( Confidential ) for incidence management and resolution of outages.
Represented Confidential in Customer Advisory Council.
Capacity planning and license management.
Implemented backup and restore test.
Conducted DR test and automatic client routing test.

Confidential

SQL Server Team Lead

Responsibilities:

Confidential

Informix Database Administrator

Responsibilities:

Monitored Informix databases on the Solaris environment.
Setup Enterprise Replication between databases across data center for high availability.
Wrote data comparison tool in ESQL/C to validate data between replicated databases.
Developed tools in Perl to migrate Informix databases to Oracle.

Confidential

Reporting System

Responsibilities:

Developed tools and solutions using Fast CG/Perl, JavaScript and SQL Server 2000.
Worked closely with application teams to identify business challenges and develop technical solutions.

Confidential

SQL Server Database Administrator

Responsibilities:

Collaborated with the team members to streamline processes and improve technical operations.
Successfully developed tools to monitor database performance and analyze performance metrics of the database server to improve functionality and efficiency.