Senior Database Developer Resume Samples

Description :

1. Worked extensively on developing E-Verify PL/SQL packages (More than 50 packages).
2. Prepared template for the test cases required for testing Oracle stored packages, procedures, Functions, and reports.
3. Worked on modifying and testing Oracle and Discoverer reports.
4. Fixed the dynamic ref cursors memory problem in Oracle reports at a client.
5. Created a PL/SQL package for generating the PL/SQL code for the table packages for inserting, updating, getting, and deleting the data from the table.
6. Generated package also takes care of indenting, the standard established practices, and naming conventions for the consistency purpose.
7. Developed the PL/SQL package and taken the responsibility for loading HUD batch data for the given E-Verify agency from an excel spreadsheet into Oracle database for creating departments, groups, and users.
8. Taken the responsibility for loading and testing all the E-Verify tutorials.

Experience

2-5 Years

Level

Junior

Education

M.S. In Operations

Description :

1. Developed to handle the overall business.
2. Consisted of ATM reconciliation, Dispute Management, Transaction Reconciliation and Cash Management.
3. Created a ticket along with various categories and business logic and ensures the ticket get closed as per system driven deadlines.
4. Required automated trouble ticket queuing system for 200 NOC users where the team was working 24/7 to handle ATM issues.
5. Developed tables, stored procedures, and other SQL server object to support the reporting team.
6. Recovered historical transaction data from multiple data sources and loaded it into dw.
7. Investigated and resolved production issues related to the data exchange.

Experience

5-7 Years

Level

Executive

Education

Information Technology

Description :

1. Installed and configured SQL Server on new servers with service packs.
   
2. Supported and troubleshot very large databases (VLDB).
3. Worked on Snapshot and Transactional Replication.
4. Worked on 32 bit, x64 bit clustered and standalone environments.
5. Configured the RAID levels for data files, log files and tempdb at the server level.
6. Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
7. Deployed SSRS Reports across multiple environments including Test, Production and supporting environments Developed cubes for reporting based on the business requirements using SSAS 2008 Performed data extraction from OLTP to OLAP for decision making using SSIS.

Experience

5-7 Years

Level

Executive

Education

Information Systems

Description :

1. Developed to automate most of the data flow between IT, Business and involved trading, payment and adjustment platforms.
2. Automated process also took care of mathematics and calculations which used to be done by business by spending an excess of human effort and resources.
3. Proposed solution provides the ability to the user to Onboard clients.
4. Provided facility to search and maintain clients and accounts.
5. Responsible to automatically synchronize data between multiple applications where accounts management is provided.
6. Focused on using new technology and migration entire data model to use new workflow tools.
7. Able to use both systems without worrying about doing duplicate work in both systems.

Experience

7-10 Years

Level

Management

Education

Engineering

Description :

1. Focused on emerging markets where there is a high demand for insurance, savings & investment products.
2. Performed Server installation and configuration using SQL Server.
3. Fixed bugs on Payouts and Correspondence letters send to Third Party Clients.
4. Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
5. Developed Business requirement (BRD), Functional requirement (FRD) documents, keep track of changes in BRD, FRD documents.
6. Worked with Subject Matter Experts (SMEs) to gather/clarify business requirements for data and reporting.
7. Converted business requirements and rules into technical specifications in accordance with standards, including but not limited to, field-to-field mappings.

Experience

2-5 Years

Level

Junior

Education

Bachelors Of Science

Description :

1. Investigated and fixed issues related to the legacy warehouse load process (SSIS).
2. Recovered and improved ssis, ETL solution to load a new data warehouse.
3. Participated in a full cycle of software development including testing and maintenance of the QA environment.
4. Enhanced and maintained an existing set of ETL jobs and processes built with SQL server agent and integration services used to feed a third party system.
5. Participated in the hdc3 application conversion for various reports using oracle pl/SQL.
6. Developed hedis monthly and annual tracking reports using oracle pl/SQL.
7. Performed back-end testing using SQL queries, SQL profiler, and the database engine tuning advisor.

Experience

7-10 Years

Level

Management

Education

Information Technology

Description :

1. Responsible for all aspects of projects from gathering requirements, designing, coding, testing, documenting, implementing, training, support, and maintenance of applications.
2. Wrote stored procedures, views, triggers and functions in support of the applications.
3. Designed DTS packages to integrate and transform data from various source into SQL Server databases.
   
4. Responsible for backup/recovery, data integrity, and database maintenance and good health plans.
5. Ensured database consistency.
6. Monitored database growth and capacity planning.
7. Worked with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.

Experience

7-10 Years

Level

Management

Education

B.S. In Computer Science

Description :

1. Configured features, Originate provides more control over workflow and delivers fast, reliable decisions to help lenders effectively manage risk and improve productivity.
2. Worked in all phases of the SDLC process to implement this project.
3. Participated in the Database Design having Data Model, ER Diagrams, Process Flow Charts using Erwin Tool.
4. Coordinated with the front end design team to provide them with the necessary stored Procedures, Functions and Packages and the necessary insight into the data.
5. Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF, and autocracy.
6. Created Indexes on the tables for faster retrieval of the data to enhance database performance.
7. Involved in table redesigning with the implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.

Experience

2-5 Years

Level

Junior

Education

BA In Communications

Description :

1. Aligned data standards and concurrency models, and database configurations for product and ad-hoc projects; created database objects in Oracle, DB2, and SQL Server aligned with technical specifications.
2. Worked with the architecture group on data architecture topics, new database paradigms, and data access mechanisms; optimized, tuned, and implemented data models on multiple DBMS platforms.
3. Performed ETL operations on external tables, databases, and systems; modified existing Java programs for testing/enhancement.
4. Provided advice and guidance to Agile members on population and how to maintain the Jira burndown chart.
5. Completed sprint retrospectives, reviews, and planning sessions.
6. Evaluated hardware/software to support ever-increasing computational and data loads; recommending solutions.
7. Evaluated and implemented the Trader Desktop and offered applicable advice to executives for purchase recommendations.
8. Managed, educated, and mentored global programmers.
9. Analyzed and diagnosed database issues from services and customer support groups.

Experience

7-10 Years

Level

Management

Education

Liberal Arts

Description :

1. Provided consumer financing options for merchants and service providers, specializing in the underserved sub-prime credit segments.
2. Sophisticated analytics that helps partners better understand their customers and their business.
3. Designed and modeled database structure to support business needs using ER/Studio.
4. Developed and supported web financial systems using MS SQL Server and T-SQL coding.
5. Maintained successfully windows applications programming in C# as needed.
6. Developed SSIS packages to export and import data across environments with different business logic.
7. Created stored procedure, indexes, and views using complex queries and scripting.
8. Involved in critical database releases to testing, staging, and production environments.
9. Used SQL Profiler to troubleshoot issues and for query optimization.

Experience

7-10 Years

Level

Management

Education

Master Of Science