We provide IT Staff Augmentation Services!

Database Developer Resume

FL

SUMMARY:

  • Having 8 Years of experience in development, design, implementation and maintenance of software projects using Oracle SQL, PL/SQL and SQL Server, PostgreSQL and UNIX.
  • Strong experience in Oracle SQL and PL/SQL.
  • Having experience in database object creation and modification.
  • Having experience in ETL informatica power center.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Having good experience in data cleansing, data Analysis and reporting.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Proficient in modelling data by writing the SQL Queries to retrieve the information from the Database.
  • Create reports for executives and all departments to get insights from data.
  • Responsible for database architecture and development.
  • Lead the development, deployment, and maintenance of a performance dashboard.
  • Having good experience in Telecom, Banking and Healthcare.

TECHNICAL SKILLS:

Oracle SQL, Pl/SQL, DBA, SQL Server, UNIX, Shell Scripting, SQL, ERWIN, ER Studio, SOAP UI, Control - M, HP ALM, SOAP UI, REMEDY, AWS, Ansible, Chef and Puppet

PROFESSIONAL EXPERIENCE:

Confidential, FL

Database Developer

Responsibilities:

  • Experience with Autonomous Transactions, database trigger, Indexes.
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Developed various Unix Shell scripts and PL/SQL procedures to automate different job tasks and environment setups.
  • Experience with Oracle different versions like 10G, 11i and 12C.
  • Worked on UNIX and Windows environments.
  • Experience with Technical Documents and design documents.
  • Experience with oracle utilities.
  • Worked on Data Migration, Development and support projects.

Confidential, Rockville, MD

Database Developer

Responsibilities:

  • Involved in modifying various existing various database objects.
  • Involved in the Analyzing and monitoring the system performance and tune accordingly.
  • Conducted analysis and feasibility studies for development of Oracle Exadata solutions.
  • Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
  • Designed and developed Oracle forms & reports generating up to 60 reports.
  • Performed modifications on existing form as per change request and maintained it.
  • Used Crystal Reports to track logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.
  • Maintained all documents of Oracle database operations.
  • Prepared documentation of Database Backup and Recovery standards.
  • Working alongside the programmers and contributing to the development process, Enabling and analyzing trace files.
  • Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents

Confidential

Database Analyst

Responsibilities:

  • Engaged with customer for requirement understanding.
  • Involved in modifying various existing various database objects.
  • Proficiency in Lean- Agile process, Scrum process development.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Communicated with business customers to discuss the issues and requirements.
  • Created shell scripts to fine tune the ETL flow of the Informatica workflows.
  • Effectively worked on Onsite and Offshore work model.
  • Pre and post session assignment variables were used to pass the variable values from one session to other.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
  • Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
  • Performed unit testing Confidential various levels of the ETL and actively involved in team code reviews.
  • Identified problems in existing production data and developed one-time scripts to correct them. Modifying the DB queries for test data for crystal reports purpose.

Confidential

Database Developer

Responsibilities:

  • Create PL/SQL packages, standalone procedures, and functions.
  • Developed various Unix Shell scripts and PL/SQL procedures to automate different job tasks and environment setups.
  • UNIX system shell scripts for billing system programming, integration and for operating system duties.
  • Data Migration and Warehousing. Additionally, mentored and supported the Agile team
  • Modifying the DB queries for test data for crystal reports purpose.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, matrix, charts, sub-reports, navigation reports (Hyperlink) etc.
  • Created different Parameterized Reports (SSRS), which consist of, report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Report parameters included single valued parameters, multi-value parameters that also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Created Linked reports, Ad-hoc reports, based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
  • Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using analyse to compute statistics on tables.

Confidential

Database Developer

Responsibilities:

  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Expertise in writing shell scripts for automation, and monitoring using Shell
  • Used Shell scripts to automate tasks in the Linux environment.
  • Written shell scripts across the UNIX and windows environment.
  • Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
  • Involved in creating data model, creating transformation for source data and scheduling ETL processes.
  • Created set of SSIS ETL components for loading Confidential Centricity's EMR and EHR data to Ascend Datawarehouse.
  • Participated in the Data mart design and Data modeling for the visualization reports.
  • Automated the SSIS packages from end to end FTP to data warehouse.
  • Automated the SSIS packages from end to end FTP to data warehouse.
  • Established the enterprise wide SSIS packages Automation and SSRS Report Publishing.
  • Involved in Maintenance and Deployment of SSIS Packages.
  • Worked with system variables and creating User-Defined Variables for SSIS Packages.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).

Hire Now