preview

Example Of A Database

Decent Essays

Profile Summary Database professional with ten years of IT experience Design and develop the mission-critical, highly available, high volume OLTP databases hosted in SQL Server and Oracle Highly proficient in T-SQL and PL/SQL programming languages for creating optimized stored procedures, functions, triggers, views with complex business logic Expertise in performance tuning and troubleshooting Hands-on experience in designing, building, deploying and supporting data integration with Microsoft BI using SSRS, SSIS, and DTS packages Thorough experience in database normalization and data modeling Experienced working in both Waterfall and Agile – Scrum/ Kanban development methodologies with a solid understanding of software …show more content…

Reduced the response time from over a minute to less than three seconds A few complex batch processes were taking 15 to 20 hours each to complete and impacting the daily schedule. Isolated the components which were running slower and tuned the related database code which reduced the processing time to about five times lesser
Senior Software Developer, Apollo Education Group, Inc. Apr’12 till Mar’17
Responsibilities:
Development of database packages and procedures for various complex business scenarios Working with upstream and downstream applications, write queries and procedures as per their requirements, create test data, and help them understand the business process and the data Part of a cross-trained team with participation in development, review, and testing
Key accomplishments and recognitions: Migrated out of warranty SQL Server 2000/2005 databases into SQL Server 2012 within time frame and budget ensuring compliance and security of company's most critical student data Reduced complexity with multi-system dependency by converting more than 20 DTS packages into SSIS jobs used for aggregating data from heterogeneous systems for analysis and decision-making Re-engineered the program approval process for the University. Simplified the design used by application services and user interface Improved system performance by converting legacy codes into optimized SQL and PL/SQL packages which in turn saved company costs

Get Access