Database Programmer Resume

OBJECTIVE

To obtain an IT position that utilizes my experience as an IT Lead having responsibility for all aspects of IT including managing the subordinates and implementing the projects.

SUMMARY

8+ years of experience in Database Developer, Design and Development and Boomi Integration Engineer.
3+ years experience in Dell Boomi Development.
Designed and developed integration using the Boomi AtomSphere integration platform
Experience in Dell Boomi components, connectors, Application Source Qualifier, Mapping Designer and Transformations
Knowledge of Rest API, SOAP framework, XML, Web service design
Experience in creating interfaces for upstream/downstream applications
Good knowledge of SQL, Linux, and AWS cloud services.
Development experience in program languages like Java/Groovy/ XML/XSLT, etc.
Over yearsof database experience as anOracle 10g, 11g, Oracle SQL PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Database.
Strong Exposure in writing Simple and ComplexSQLs, PL/SQL Functions and Procedures and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
Created external tables to transfer .csv files to tables and from tables to .csv using the standard package utl file.
Significant experience in 24/7 Production Environment Support.

TECHNICAL SKILLS

Integration Tools: Boomi

Database: Oracle 10g,11g.

Languages: SQL, PL/SQL

Cloud Platforms: Databricks and AWS

OS: Windows, Linux

PROFESSIONAL EXPERIENCE

Confidential

RESPONSIBILITIES:

On daily basis, Chegg partners post their data in form of files from various sources like sales force and sftp. we as a team process those files and load them into Database.
Handling Production issues with Real-time interfaces and Process Monitoring of Batch issues.
Monitoring work scheduler and quick checks every hour on batch running.
Checking user activities, slowest components, memory consumption and average response time.
Worked on request tickets, and incidents, monitoring job failures, and resolving failures. Working towards permanent fixes over production batches.
Data validation between source and destination.
Integration between Salesforce and SFTP and SFTP and Database..
Involved in developing Process, Maps Connector configurations etc.
Worked on XML, Flat file and Database Profiles.
Worked on connectors like Web services Server, SAP, SFTP, Mail
Coordination with the onsite team to gather accurate requirements.
Involved in testing, System Integration testing and User Acceptance Testing
Implemented error handling mechanism

Confidential

Database Programmer

Responsibilities:

Good knowledge of the Banking domain (financial /Lending).
I have the ability to manage Production / Application Support for various Live Applications run by Bank.
Creating and managing the database, database users, granting objects and system privileges
Creating objects as per the developer’s requirement.
Provided SQL queries for analysis and reporting purposes.
Query creation for data Extraction for Business on production.
Loading the data stored in S3 directly into the Qubole tables
Checking and Killing Blocking Sessions
Creating stored procedures using dynamic SQL for Reports.
Created PL/SQL to create Pl/SQL Blocks, Cursors, Procedures, and Triggers.
Performed Database of all database objects includingtables, indexes, views, stored procedures, functions, triggers, and PL/SQL blocks.
Created Tables, Views, Constraints, indexes
Created external tables to transfer .csv files to tables and from tables to .csv using the standard package utl file.

Confidential

Database Programmer

Responsibilities:

Creating stored procedures using dynamic SQL for Reports.
Created PL/SQL to create Pl/SQL Blocks, Cursors, Procedures, and Triggers.
Performed Database of all database objects includingtables, indexes, views, stored procedures, functions, triggers, and PL/SQL blocks.
Created Tables, Views, Constraints, indexes
Experience in DML, DDL, DCL, TCL commands and SQL functions.
Experience in complex Query joins sub-queries and correlated subqueries
Logical Backups, Export/Import.
Maintaining the Cold and Hot backups of the databases.
Maintenance of Database and Listener.