Lead Database Engineer Resume

SUMMARY

Fourteen years of experience working in the information technology field.
Proficient in a variety of relational database management systems running on UNIX and Windows platforms with emphasis in PostgreSQL and MySQL at an administrative and development capacity.
In - depth involvement in the architecture of complex multi-terabyte, high-availability systems using classic and cluster-based replication with emphasis on security model.
Extensive query optimization experience, performing server tune-ups and implementing indexation strategies in conjunction with significant knowledge of cost model and parser/analyzer.

PROFESSIONAL EXPERIENCE

Lead Database Engineer

Confidential

Responsibilities:

Design data architecture for our online gaming registration, funding, VIP loyalty program, bonus rules engine and AES-256 encryption pieces.
Design data structures to enable integration among data modules and gaming content providers.
Set up and maintain data environments for QA, development, production and automatic testing using a mix of MySQL classic replication (INNODB) and clustering (NDB-sharding).
Extensive development of business logic as a collection of stored procedures, functions and triggers in close coordination with scrum teams writing wrapper services.
Coordinate issuance of DDL patches per environment with release engineering to enable code deployments.
Database code optimization through a variety of approaches: indexation, query re-writing and MySQL settings tune-up upon analysis of a query optimizer trace and cost analysis.
Coordinate with system architect, system administrator, design and development scrum teams to fulfill data architecture requirements.
Design and implement data partitioning and archival strategy, database object permission model and backup/disaster recovery strategy
Participate in scrum ceremonies: grooming, sprint planning and demo sessions to provide data architecture insights and gather business logic requirements for database code development user stories
Maintain updated documentation: data dictionary, E/R diagrams, replication diagrams, cron-jobs, seed data, and DDL patch release and backup scripts

Software Engineer/Database Administrator

Confidential

Responsibilities:

Administration of various open-source relational database management systems including the latest version of MySQL and several multi-terabyte PostgreSQL servers on Linux and Solaris platforms.
Extensive database development using PG/PLSQL and Transact-SQL.
Platform migration, version upgrades, maintenance, database re-engineering and performance tune-up.
Extensive development in scripting languages
Design and implementation of the backup strategy and storage/capacity planning.
Maintenance of legacy applications written in C/C++.
Development of a wide range of applications in C/C++ and Visual C# to implement the capture, processing and statistical analysis of real-time stock market trade flow data.
Report design and implementation using the latest version of Crystal Reports.
Miscellaneous data processing tasks, including but not limited to data manipulation and conversion
User support, documentation and testing.

Software Engineer

Confidential

Responsibilities:

Maintenance of legacy applications written in C/C++, Visual C++, SQL Server and Access.
User support, documentation and testing.

Project Engineer I and II / Project Leader I

Confidential

Responsibilities:

Engineering Department Intern

Confidential

Responsibilities:

Basic hardware assembly and installation.
Evaluation of new technologies and implemented a small-scale client-server solution that helped organize and speed up the building permit application workflow using Visual Basic and Access.
Basic Computer maintenance and network support.