LEELA SATULURI, M.S.

Pembroke Pines, FL

954-***-**** ac0ded@r.postjobfree.com

SUMMARY

About 10 years of IT experience providing database administrative support and programming. Result-focused, organized, and detail-oriented with ability to prioritize and undertake tasks efficiently for on-time project delivery within a team environment. Resourceful to drive proficiency with databases administration and development, while ascertaining high availability and performance. Creative and superior programmer seeking a DBA/Senior Programmer role.

Expertise with RDBMS using SQL and PL/SQL.

Knowledge in Analysis, Design and Implementation of Business Applications using RDBMS (Oracle 12c, 11gr2 PL/SQL).

Excellent knowledge of PL/SQL, T-SQL developing packages, procedures, functions and triggers.

Worked extensively to achieve high availability of databases.

Provided on-call support for deploying and trouble shooting.

Experienced with cloning, creating new database, hot and cold backup using manual or RMAN.

Knowledge of high availability options in SQL server, such as mirroring, fail-over clustering, log shipping.

Worked in varied operating systems, such as UNIX, Windows.

Knowledge of Data warehouse techniques using SSIS, SSRS, Micro Strategy and Cognos

Involved in all phases of SDLC, worked in development methodologies, such as Agile, Scrum, test driven, Rapid application Development, and Waterfall.

Performance Tuning and query optimization

Excellent communication, interpersonal and analytical skills, great team player, efficient operation at all pressure levels.

Mentored new employees using presentations and documents (step by step process).

Developed and managed a client-specific package that was used by testing teams.

Created and managed an innovative utility tool (DBA_Util) to perform frequent DBA tasks (being extensively used by deployment teams).

SKILL SET

Oracle 12c, Oracle 11gr2, Oracle 10g, Oracle 9i, MS SQLSERVER 2012,2008, SQL *PLUS, SQL*LOADER,MS Management Studio, SSDT (SQL DATA TOOLS) SSIS,SSAS,SSRS, .NET, Embarcadero, SQL Developer, VB.net, ADO, C, C++,C#,CVS, PVCS, Visual Studio, Putty, Windows, UNIX, Linux, Ubuntu, Gedit, Vi and Mercury quality center, TKPROF, EXPLAIN PLAN, SQL*Plus Auto trace, DAYBREAK software

EDUCATION

Master’s in Computer Applications.

PROFESSIONAL EXPERIENCE

Consultant January17-till date

CSL-Plasma

Played a lead Application Developer role working on data migration and integration plans for converting historical data from sqlserver into Oracle database.

Setup linked servers to work on remote sqlserver.

Developed SSIS packages and created integration process to synchronize data between the MSSQL and Oracle.

Automated the data synchronization data integration process to run every day in test and production databases.

Developed UNIX shell script and batch scripts to automate processing of input data from various 3rd party sources.

Extensively used windows schedulers and cron for automation.

Business Systems Manager August16-December2016

CFG

Responsible for maintenance of a customized legacy 3rd party lending software “DAYBREAK”.

Worked towards implementing software upgrade to the database while eliminating the impact on the 3rd party software.

Promoted a positive transparent relationship between various outsourcing teams and enhanced technical coordination amongst the operations team and development teams.

Worked as a liaison coordinating with business and technical teams.

Worked closely with DBA during database upgrades, enhancements and regular maintenance.

Responsible for enhancement of reports/ external operational programs for DAYBREAK.

Implemented solutions for the system using Oracle SQL Server side script solutions and other reporting solutions.

Design and implement test plans for new add-ins to the DAYBREAK software.

Worked with Operations Support for Daily Ad-hoc situations.

Senior PL/SQL Programmer / Associate DBA 2013 – July 2016

Tracfone Wireless

Provided database administrative services for development and test environments for multiple projects.

Efficiently reduced high cost resource consumption using Performance tuning techniques TKPROF.

Introduced proactive database health check to reduce run time issues.

Created program unit to run on cron or DBMS jobs to periodically check and resolve any data discrepancy.

Initiated time sensitive solutions to synchronize data across development/test and production database.

Constantly monitoring and debugging database for consistency, striving towards high availability.

Developed Unix Shell Scripts for maintenance tasks, such as backup and recovery to execute on demand.

Conversant with cold and hot backup using manual as well as RMAN Automatic backups.

Mentored new hires by periodic knowledge transfer presentation.

Lead a Team of offshore DBA providing support with escalations.

Managed and developed a package for integration team to help during test cycles of new software releases.

Designed runbook to be used by new hire DBAs with little or no systems knowledge.

Senior Programmer Analyst 2010 –2013

Tracfone Wireless

Involved in transformation of logical data architectures into physical data designs creating ER diagrams, Dataflow diagrams, and design documents for new projects.

Created technical design documents for new projects adhering to industry design standards.

Played a lead Application developer role working in all stages of SDLC.

Worked with product development team to prioritize features based latest industry trends

Tuned SQL queries using EXPLAIN PLAN and SQL*Plus Auto trace report for query optimization.

Efficiently managed new data requirements to incorporate solutions to known defects to reduce release costs significantly.

Effectively Provided SQL support to help desk escalations.

Oracle PL/SQL Developer

Tracfone Wireless 2008 –2010

Developed database objects including tables, Indexes, Materialized views, sequences, packages, procedures, Triggers, reference cursors, Dynamic SQL.

Created Tables, Views, Constraints, Indexes (B Tree, Bitmap and Function Based).

Worked extensively on Ref Cursor, External Table and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Involved in unit testing and integration testing, end to end testing as well as coordination with development and testing teams.

Team Leader 2007- 2008

IT Consultancy Company

Communicated efficiently, in project coordinator’s role, with technical development teams as well as non-technical business managers, prioritizing features to showcase latest technology/industry trends.

Played multiple roles, such as a team lead, Hands-on delivery manager involved in design and development and as a point of contact for end users.

Involved in system architecture and detailed design document.

Project developed Using VB.net 2005 and SQL server.

Contact this candidate