Database Application DBA/ Developer Resume

SUMMARY

Monitoring, trouble shooting and optimizing database performance in MySQL, MS SQL, Oracle and PostgreSQL
Experienced in designing, Implementing CI/CD pipelines in Oracle and PostgreSQL on hosted or AWS platforms (Aurora RDS)
Expertise in migrating/rewriting code from PL/SQL to PL/pgSQL
Implementation expertise - configuring, administering and employing extreme high speed in-memory transactions with MySQL, MS SQL and PostgreSQL on WIN and Linux platforms using ram disk/tmpfs
Expertise in coding optimized SQL scripts handling multiple tables, containing upwards of 500+ Million rows data in MySQL, MS SQL, Oracle and PostgreSQL
Expertise in JSON/XML/String/Numeric/Array/Cursor processing in Oracle, MS SQL and PostgreSQL
Experienced in scripting, monitoring and optimizing Parallel processing of PgSQL DML
Experienced in manual/automated data migration, foreign data wrappers and simultaneous access between MS SQL, MySQL, Oracle and PgSQL using native drivers and/or ODBC links and/or DMS/CDC.
Experienced in SQL optimization, performance tuning, writing complex SQL queries, stored procedures, functions, data massaging and data Export/Import in Oracle, PostgreSQL, My SQL and MSSQL server
Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
Fluent in writing test cases to test DB Objects, Procedures, functions and packages in Oracle and PostgreSQL.
Good noledge of optimizing slow running queries by monitoring SGA & PGA execution params or in OEM
Expertise in Web Content management. Implementation expertise with websites delivering millions of web pages generated from RDBMS in tandem with CGI/SSI scripts, DHTML, Javascript and CSS scripts generated on change/pull/request.
Hardware/Firmware Processor level understanding of processing data by different RDBMS.
Functional experience with i8085/86 assembly language and understanding of multi core processing since Motorola Z80 processors.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship