Database Developer Resume Samples

Description :

1. Established the global asset protection teams to promote the safe use of its platforms and to collaborate with local, national and international law enforcement in apprehending and prosecuting criminals.
2. Involving in the development, maintenance, and enhancement of the PIX application.
3. Working closely with the business analysts and business users to understand the business requirements.
4. Involving in the PL/SQL code review and modification for the development of new requirements.
5. Developing custom stored procedures and packages to support new enhancement needs.
6. Using the business object reports to generate reports using ref cursors that were passed from PL/SQL procedures.
7. Involving in production operation team for managing code merge. Handing production support tickets.
8. Writing shell scripts that assisted in the migration of data and creation of custom views which served as primary tools for analysis.
9. Also writing scripts to enable database purge of related queries/functions/procedures which were found to be either old or causing performance issues.
10. Using SQL loader to upload bulk data by writing scripts for the control file in order to migrate the data from legacy system CSV files to production.

Experience

7-10 Years

Level

Management

Education

BS

Description :

1. Responsible for providing solutions to all data related needs to support existing and new applications.
2. Acted as the single resource to design, develop and deliver database solutions to support in-house built applicant tracking system "opportunityteam.org" and office management system “office manager”.
3. Took the lead role in designing databases to house all "OTO" data in all 5 different environments (Prod, Staging, QA, Dev, and Support).
4. Involved in every step from the beginning stages of the projects with requirement gathering to implementation and maintenance.
5. Designed and created table structures for applicant OB/IB messages (email/voice/text), resumes/notes/ratings, applicant sharing and blocking, archiving, office hierarchy and office personnel hierarchy and history, campaign distribution.
6. Developed and maintained numerous complex near real-time ETLS to extract the data from multiple source systems like Oracle, SQL server, and flat files and loaded into SQL 2014 using SSIS.
7. Developed ETLS to push data into Salesforce objects from OTO servers using Informatica Cloud.
8. Designed and developed numerous complex queries, views, functions and stored procedures to work seamlessly with Appdev teams data needs.
9. Optimized performances of many stored procedures, T-SQL queries to deliver big amounts of data under two seconds.
10. Successfully optimized "security" control etl (used for application security) by a big margin (from 20+ mins to 11 secs) by applying performance tuning techniques like query tuning and parallel processing.
11. Extensively used SolarWinds (database monitoring tool) to monitor servers for deadlocks, long running queries, stored procedures and performed performance tuning as necessary.
12. Worked with multiple teams to design, develop and deliver early warning system.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Creating SSIS packages for data importing, cleansing, and parsing etc. Extracted, cleaned and validated.
2. Creating complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
3. Scheduling the cube processing from staging database tables using SQL server agent.
4. Wrote MDX queries and expressions for use in Front End BI applications.
5. Generating reports using SQL server reporting services2005/2008 from OLTP and OLAP data sources.
6. Designing and deploying reports with drill down, drill through and drop down menu option and parameterized and linked reports.
7. Deploying and scheduling reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
8. Preparing the layouts by placing the fields in the appropriate place according to the requirement of the final report.
9. Creating standard report subscriptions and data driven report subscriptions.
10. Creating report snapshots and cache for better performance. 
11. Creating several materialized views and UDFS to be accessed by the new front end applications.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Currently working as an Oracle database developer/certified Oracle instructor/trainer for Netcliff.
2. Teaching Oracle SQL 11g/10g, Oracle PL/SQL 11g, Oracle forms 11g/10g and Oracle reports 11g/10g.
3. Providing the training for Oracle certifications and for jobs in Oracle for the students to work as Oracle developers.
4. Actively involved in maintaining the students' management system with the admission process, payment plans and strategies of students for the various courses.
5. Working as a developer to automate and process the students registration process and payment plans.
6. Working as a technical writer for producing process flow diagrams and ER diagrams for the full SDLC.
7. Developing the students' management system to create and maintain students database.
8. Creating tables to store information on students, courses they are taking and payments.
9. Creating procedures so that when student ID is entered all his/her details are displayed.
10. Creating functions to return the payment amount the students paid or are going to pay.
11. Creating and maintaining the database of customers or clients, accounts payables, accounts.
12. Keeping a track of accounts payables and receivables for clients depending on the no of.

Experience

5-7 Years

Level

Senior

Education

BS

Description :

1. Rapidly responding by adopting new technologies through leveraging cloud architectures.
2. Architecting new applications and re-architecting the selected applications to the cloud-native or cloud-enabled.
3. Developing applications using NoSQL data manipulation technologies - especially MongoDB.
4. Working with ad-hoc queries, indexing, and real-time data aggregation with MongoDB.
5. Working with MongoDB different challenges like data migration from, Oracle to MongoDB query migration, MongoDB query construction for new business requirements.
6. Responsible for creating and modifying the PL/SQL procedures, functions & packages according to the business requirement.
7. Creating the database objects like stored procedures, function, packages, cursor, ref cursor and triggers.
8. Writing and modifying Oracle SQL statements and PL/SQL procedures and functions that are called in the Java methods to implement microservices.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Engineering

Description :

1. Assisting more than 70 clients in planning, designing, implementing, and modifying the database.
2. Became the programmer of choice for projects that required complex programming.
3. Spearheaded the first implementation with quest diagnostics for orders and results.
4. Designing and implementing the custom function for parsing result messages from Panther.
5. Designing and implementing a module for AP easy that added the functionality of entering a dynamic library of questions with multiple choice answers.
6. Assisting in creating, reviewing, and updating hl7 implementation specifications for both inbound and outbound interface messages.
7. Designing and implementing a module for AP easy lis for clinical orders and results.
8. Assisted in designing hl7 specification for billing software and implemented the first interface between ap easy lis and easy billing pro.
9. Developed a bar-coding system which allowed users to search for records and navigate.
10. Created a custom function for calculating turnaround time while excluding specific.
11. Created custom label module that allowed end-users to store custom slide label layouts.
12. Created a custom function for parsing blocks of text in to lines of text limited to a character length set by the end-user.

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Developing and maintaining various database systems and applications in development, test and production environments.
2. Creating and deploying the SSRS reports on numerous data sources within the organization.
3. Wrote T-SQL queries and stored procedures for various CRUD and ETL operations.
4. Implemented BI360 data warehouse which allows for a single source of reporting on multi-company and multi-currency financial data within Minitab.
5. Moved from SQL server 2008 r2 to SQL server 2014; modified custom code to ensure compatibility.
6. Upgrading quality trainer, a subscription-based web product, from one version to another.
7. Responsible for the data migration portion of the project, which included a mass update of hundreds of thousands of rows.
8. Converted stored procedures for SSRS reports from using ONYX objects to Dynamics CRM objects (tables, views).
9. Created and deployed SSRS reports for internal users that included product trial, launch and activation data.
10. Implemented integration between SSRS and SharePoint 2007 for company-wide reporting.
11. Converted crystal reports into SSRS reports using stored procedure data sources.
12. Writing front-end web application with a SQL server database back-end, which stored data about all of Minitab’s products and releases.

Experience

10+ Years

Level

Consultant

Education

Associates

Description :

1. Experience working in agile environment, and attended daily scrum meetings.
2. Creating several ETL packages using SSIS for loading data, creating member/claim files for counties, to work on several inbound and outbound jobs.
3. Creating stored procedures, functions, and views in MySQL to support the SSIS packages, console applications, SSRS reporting, and data warehouse purposes.
4. Improving the performance by creating indexes, splitting the query, reducing the number of rows/columns when not required etc.
5. On-demand learned Powershell scripting and used it while developing console applications using C#.
6. Creating reports using SSRS to make data speak visually using various types of graphs and charts.
7. Working along with the DBA and deploying the SSIS packages on to the server both at package and project level.
8. Working on creating the fee schedules, loading DTRR file, provider and member conversion, generating ID cards for members, and several other major tasks.
9. Working together with Quality Analyst and Business Analyst to make sure all the business requirements are covered for the product.

Experience

2-5 Years

Level

Junior

Education

MS

Description :

1. Providing client/server based technical support, database creation in Microsoft SQL server 2008/2012 database, maintenance, enhance performance & technical troubleshooting for current database, system analysis, database designing, creating SQL statements, installation software and customization.
2. Writing and troubleshooting the T-SQL code and writing the stored procedures, functions, triggers and working putting constraints on tables.
3. Developing database role security solution for financial, employees and students data.
4. Using Report Builder, Microsoft Sql Server Data Tools (SDT) to create customized report in SSRS.
5. Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat file, excel files and ensure proper implementation of event handlers, logging, checkpoints, transaction and package configurations.
6. Scheduling reports for daily, weekly and monthly reports for executive, business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services (SSRS).

Experience

7-10 Years

Level

Senior

Education

MS

Description :

1. Supported the development from design through production release, utilizing Oracle database, Dynamic PL/SQL, SQL, Unix shell scripting, SQL loader.
2. Code testing following TDD practices including maintenance/creation of unit tests and collaborating with functional and non-functional test team members to ensure quality output.
3. Elaboration of functional requirements provided by the business including working with a cross-functional team of product owners, business analysts, project managers, QA testers and technical designers.
4. Collaborating with technical specialists during creation of the functional requirements document.
5. Data migration project: migration of modules such as: accounts, users, equotes, ibuy, and orders from atg to websphere commerce database.
6. Creating the database objects such as: packages, procedures, functions, tables, views, external tables and unix scripts to migrate the data.
7. Code testing: testing the requirements functionality and prepared unit testing according to requirements.
8. Documentation: providing release notes to the production release team, and creating any additional guide to illustrate the whole functionality.

Experience

5-7 Years

Level

Executive

Education

BS