Jr SQL Developer Resume Houston, TX - Hire IT People

SUMMARY

creating, modifying and maintaining commodity and trading tables for crude, refined and finished products
Responsible for creating, monitoring and troubleshooting multiple intra - day and nightly agent jobs
Creating necessary Indexes for improving the performance of the database
Created Stored Procedures for commonly used complex queries across multiple commodity types involving join and union of multiple tables.
Optimized data integrity by utilizing constraints and functions
Utilized Triggers to facilitate consistent data entry into the database and to keep track of changes to the attributes of the table
Created Views to facilitate easy user interface, row/column level security
Proficiency in creating simple tabular and matrix reports using SSRS

TECHNICAL SKILLS

Database: SQL Server Management Studio 2014/16, SSIS, SSRS, MySQL

Tools: MSOffice suite, PAC2K change management studio, SharePoint, HP Lifecycle Manger (QC)

PROFESSIONAL EXPERIENCE

Confidential,Houston, TX

Jr SQL Developer

Responsibilities:

Responsible for creating, modifying and maintaining commodity and trading tables for crude, refined and finished products
Responsible for creating, monitoring and troubleshooting multiple intra-day and nightly agent jobs
Creating necessary Indexes for improving the performance of the database
Created Stored Procedures for commonly used complex queries across multiple commodity types involving join and union of multiple tables.
Optimized data integrity by utilizing constraints and functions
Utilized Triggers to facilitate consistent data entry into the database and to keep track of changes to the attributes of the table
Created Views to facilitate easy user interface, row/column level security
Proficiency in creating simple tabular and matrix reports using SSRS
Created parameterized (including cascading parameters), Drill-down, Drill-through, linked, lists, templates and sub reports
Involved in design/developing, managing and deploying reports in MS SQL Server environment using SSRS
Designed SSIS Packages to transfer data from various sources to various destinations using Business Intelligence Development Studio
Analyze data formats, design the necessary transformations to map the source data to the destination, adding and configuring connection manager for source and destination
Adding and configuring various transformations like lookup, derived column, data conversion, aggregate, conditional split, merge, merge join, row count and union
Involved in the complete life cycle of extract-transform-load process including the design, development and moving data from the enterprise System Of Record to various commodity trading LOBs
Involved in designing and developing ETL packages using Business Intelligence Development Studio (BIDS)
Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent and schedule SSIS Packages .
Knowledge in using event handlers for assigning events at package and task level to handle errors

Confidential

Jr. SQL Developer/DBA

Responsibilities:

Experience in creating, maintaining and implementing SQL scripts
Knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types and Indexes
Implemented Functions and enforced business rules via checks and constraints .
Responsible for the overall change control process to implement appropriate change requests and work orders through testing and production
Rebuilding the indexes at regular intervals for better performance
Experience in implementing c lustering and mirroring for maintaining High availability solutions
Involved in database migration from previous to new versions of SQL Server studio
Involved in daily monitoring tasks like verifying services availability after OS patches/Service Packs have been installed, monitoring SQL server agent jobs , monitoring database backups , verifying backups, Restoration of data, checking Error logs and disk space
Responsible for co-coordinating business meetings and generating weekly, monthly and yearly status reports using SSRS

We provide IT Staff Augmentation Services!

Jr Sql Developer Resume

Houston, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship