Senior Database Developer Resume
SUMMARY
- Over eighteen years of diverse IT experience in financial, media, publishing and educational industries.
- Proficient in all major aspects of Oracle 10g/11g/12c/18c and SQL Server 2000/2005/2008/2014 database development and administration for OLTP and Data Warehouse databases, including database logical design and application development.
- Expertise in Software Development Life Cycle, including requirement analysis, design, development, implementation and execution of projects.
- Highly motivated and detail oriented, have strong analytical and problem solving skills as well as good communication and interpersonal skills. Quick learner, successful self - starter, work well under pressure, individually or as a team member.
TECHNICAL SKILLS
Languages: PL/SQL, Unix shell scripting (korn, bash), Perl, Python
Databases: Oracle 10g/ 11g / 12c / 18c; MS SQL Server 2000, 2005, 2008, 2014; DB2
O/S: Unix Solaris; Linux; MS Windows
Oracle tools: SQL*Plus, SQL Developer, Utilities (SQL*Loader, expdp, impdp), ORDS REST, AWR, ADDM, ASH, SQLT
Other tools: MS SQL Server Management Studio, ER Studio, SQL Navigator, Quest (Toad, Foglight, SharePlex), Confio, TFS, SVN, CVS (Sniff, ClearCase), Visio, Crystal Reports, Tivoli, Tableau
PROFESSIONAL EXPERIENCE
Senior Database Developer
Confidential
Responsibilities:
- Work closely with senior management, business analysts and clients to gather project requirements and translated them into new technical enhancements and functionalities. Write complex stored procedures for DB2 and Oracle databases to rectify healthcare related issues for the clients. Create multiple database objects including tables, complex packages, procedures, functions, triggers, and views using Oracle 11g, 12C and 18C to auto - upload healthcare related data. Produced multiple development modules while working extensively with Oracle 18c ORDS REST services. Write a PL/SQL ETL package to upload CA Agile JSON results into the database. Produced complex documentation describing newly created automated data solutions.
- Analyzed performance of various SQL queries by reviewing AWR, ASH, ADDM reports and queries execution plans. Redesigned PL/SQL code by using different techniques to produce optimal performance results. Introduced local indexes for partitioned tables and scripted gathering statistics for the client schemas. Compressed all tables for an Oracle Exadata 12c database by using an automated approach.
- Analyzed performance of multiple database background queries by using Tableau tool. Verified Tableau reports and dashboard functionality, data and format by matching the input against the business requirements and data gathered from the database. Filed multiple test cases and defects for the Tableau developers to rectify the issues. Worked closely with project managers, multiple QA analysts and developers to monitor the progress.
- Worked closely with business analysts and internal users to gather business requirements and converted them into new technical design. Created tables, complex packages, procedures, functions, triggers, and views using Oracle 11g. Wrote complex code and ad-hoc reports. Created monthly business reports to calculate clients budget allocations and tax returns.
- Analyzed performance of multiple SQL queries by reviewing AWR, ASH, ADDM reports and queries execution plans. Redesigned PL/SQL code by using new 11g features to produce optimal performance results. Introduced local indexes for partitioned tables and scripted gathering statistics for the client schemas. Worked extensively with the global temporary tables.
- Involved in the data center migration project. Provided recommendations for the future database physical infrastructure, memory allocation, replication strategies and backups. Resolved database related issues, including schema creation, assignment of privileges, capacity monitoring and planning. Ensured that databases support growth, change, and access demands.
Senior Database Developer
Confidential, New York, NY
Responsibilities:
- Design. Involved in database design and logical modeling, wrote and debugged PL/SQL code, Oracle jobs and testing of database applications. Wrote complex PL/SQL code to support product expansion. Established and maintained implementation of SQL standards and guidelines. Reviewed complex data models and object relational database mapping. Created customized ETL procedures and generated materialized views for Data Warehouse databases. Loaded external data through SQL*Loader, transferred data between databases via export dump and import dump utilities.
- Tuning. Identified application bottlenecks via AWR, ASH, ADDM reports, Confio, OEM, SQL Access and SQL Tuning advisors and worked on code optimization to improve delivery. Applied profiles (manually or via SQLT tool in 10g environments). Utilized Oracle 11g SQL Plan management feature along with the Automatic SQL Tuning 11g technique. Monitored access time, performed validation checks and took appropriate measures to ensure acceptable code performance. Stabilized performance of key applications for major production databases. Conducted research and evaluated different database products and development tools to support various development areas.
- Security. Implemented database auditing and documented access methods to enforce database change management, security standards and best practices. Ensured periodic review of access authorizations for users, application accounts and roles in terms of their respective compliance with SOX. Generated SOX compliance reports for the company s auditing purposes.
- Administration. Provided full range of database administration services for OLTP/DW Oracle and MS SQL Server databases on mixed operating systems. Installed, maintained, upgraded and patched database software. Created and configured new stand - alone or cluster database servers for delivery of database requests. Set up Data Guard, replication for Data Warehouse databases and configured client environments. Managed and maintained recovery procedures and backups. Supported Business Continuity planning / High availability and Disaster Recovery (DR) options. Resolved database related issues, including replication, capacity monitoring and planning, networking, security, space and memory allocation, database tuning, logical/physical backups, database and application alerts. Ensured that databases support growth, change, and access demands. Involved in the data center migration project: performed a successful migration of all lower environments to AWS
.
Sr. PL/SQL Developer / DBA
Confidential, New York, NY
Responsibilities:
- Design. Evaluated, supported, and optimized logical design of existing and new corporate technology databases. Created and maintained complex PL/SQL scripts, stored procedures, packages and functions. Redesigned and automated monthly business reports to calculate performance statistics. Guided Java developers in database areas. Worked closely with internal business clients, application developers and database administration group to facilitate full software development life cycle for new projects.
- Tuning. Improved performance, scalability and stability of database systems. Investigated data quality issues and implemented appropriate solutions. Identified and implemented programming enhancements. Conducted research and made evaluation of different database products and development tools to support various development areas. Worked in collaboration with application users to identify application bugs. Used LogMiner utility to investigate and retro - fix developers mistakes. Developed technical system documentation. Documented code in accordance with company policies, company standards and industry best practices.
- Administration. Responded to and resolved database access issues. Configured required network components to ensure proper database connectivity. Created and maintained different access control levels for end-users. Implemented recovery manager backup procedures and performed media recoveries for Oracle databases. Wrote customized backup scripts, created various maintenance procedures for MS SQL Server 2000 databases. Coordinated and perform replication of databases to test environments. Maintained disaster recovery sites and ensured proper synchronization processes with the production databases. Maintained existing or created new ad-hoc reports and data manipulation scripts to support the requirements of business users. Responsible for documenting the maintenance procedures and preparation of materials for project reviews.
- Security. Planed and implemented database security via Oracle Audit Trail for Oracle databases. Conducted research on different audit methods for MS SQL databases and implemented an audit strategy via SQL Profiler in production MS SQL environments.
Project Leader / Senior Developer
Confidential, New York, NY
Responsibilities:
- Design. Worked with customers and client service managers to gather requirements and to design enhancements and functionalities to meet the requirements. Helped define strategy for database development to enhance scalability, high availability and security. Responsible for production database logical design set up and physical implementation. Wrote complex code and ad - hoc queries for reporting purposes. Created and automated monthly business reports to calculate clients performance statistics. Guided and helped Java developers in database areas.
- Tuning. Identified database bottlenecks and tuned problematic SQL code to improve application performance. Rewrote queries to enhance performance. Gathered segment and index statistics for production databases.
- Project Management. Supervised a development team. Developed project plan and schedule. Guided database developers to write efficient code. Documented current business processes.