We provide IT Staff Augmentation Services!

Sql Developer Resume

VA

SUMMARY:

  • 6 years of experience as SQL Server Developer / DBA.
  • Experienced with SSIS/SSDT, SSRS, T - SQL, creating store procedure, trigger, functions
  • Experienced in performance monitoring and optimizing using performance tuning and sql profiler.
  • Experienced in Installation, Migration, Upgrading SQL Server 2014/2012/2008 r2
  • Experienced in creating users account, security setting and setting of jobs
  • Experienced in Index Rebuild & Reorganize, resolve index fragmentation and log space.
  • Experienced in implementing Disaster Recovery and High Availability concepts using Native tools like Clustering, Log Shipping, Mirroring and Replication and always on.

TECHNICAL SKILLS:

Database: Server 2014/2012/2008 r2

Operating System: Windows Server 2008/2003/2000

Languages: SQL, T-SQL, HTML

Data Model tool: Erwin Data Modeler

ETL Tools: SSIS/DTS, BCP

Reporting Tool: SSRS (SQL Server Reporting Services) and Tableau

Others: JIRA, TFS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, VA

SQL Developer

Responsibilities:

  • Experience in data cleansing and maintaining the data quality using the SSIS transformational tools.
  • Experience on optimizing long running queries using execution plan and performance tuning advisor.
  • Experience in ETL using SSIS/SSDT to extract data from OLEDB source or flat file and excel or other sources, transforming the source data using the transformation tools including slowly changing dimension, CDC, lookup, conditional split, merge joins, derived column, aggregates, multicast and loading the date into different destinations.
  • Experience in creating and managing Error logging, Event Handlers, creating Jobs using SQL Agent, setting Alerts and Scheduling using SSIS Packages.
  • Experience in creating tabular and matrix reports using SSRS tools to create drill down and drill through reports by passing different parameters and using mathematical operations to get calculated result.
  • Exposure working with Tableau tool to create dashboards, reports, and other data presentation formats using multiple data types.
  • Experience in writing T-SQL queries and using execution plan to evaluate the performance level of long query and optimizing the query using performance tuning advisor.
  • Maintain existing data model, create new data model and data dictionary using Erwin Data Modeler.
  • Experience in Migrating data bases from SQL server 2008R2 into 2012.
  • Experience in creating indexes, views, store procedures, trigger and functions by joining multiple tables to extract required information.
  • Perform data migration activities as per project needs using SSIS packages or using import/export.
  • Check the Error Logs, perform In-depth index analysis, identify fragmentation and Rebuilding/ Reorganize indexes, update statistics, monitor space usage and resolve space issues to enhance DB performance.
  • Experience on setting and troubleshooting of transactional replication between servers.
  • Maintain existing data model, create new data model and data dictionary using Erwin Data Modeler.
  • Monitor all job including if the jobs run successfully and monitor jobs using Job history and check for the failed jobs, investigate the route cause and resolve the issue.
  • Perform backup and restore to different Environment to ensure up-to-date information availability.
  • Created and monitored Transactional Replication and ensure data consistency between the publisher and subscriber as per the scheduled job as well as check the monitor & resolve if there are any issues.
  • Identify long running query and optimize long running query by using proper join, selective columns, CTE and applying indexes.
  • Writing database documentation, including data standards, procedures and definitions for the data dictionary and ensuring that these documents are always up to date.
  • Experienced in resolving blocking, deadlocks and log space issues by rebuilding and reorganizing index fragmentations.
  • Experience in working Agile Environment, using TFS, Jira and svn as data control repository.

Confidential, Charlotte NC

SQL Developer / DBA

Responsibilities:

  • TSQL developer including creating of stored procedures, views, and triggers;
  • Experienced in Extracting different data from different sources, Transform the data based on business requirement and load the Data to different location from sources (Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Multicast, Row count, Merge join, Lookup, Union all and other tools for analysis purpose using SSIS.
  • Experienced in creating T-SQL stored procedures and used SSIS to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Implementing ETL packages using SSIS services for integrating data from different sources using multiple transformations available in SSIS toolbox.
  • Exposure on working with analysis tool and created OLAP cubes and dimension tables for analysis purposes from different sources.
  • Responsible for performance monitoring and Troubleshooting SQL Jobs, Scheduled Tasks, Disk spaces, error logs and making recommendations for performance improvement in hosted databases which involved index creation, index removal and scheduling jobs to Rebuild/Reorg indexes and update statistics.
  • Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Involved in day-today database maintenance operations, perform regular health checks using profiler, Activity monitor, DMV and DMF and resolve slow running query using Tuning advisor.
  • Worked as a team to maintain 100 percent up time to keep the environment running irrespective of any infrastructural changes in the environment.
  • Performed backup and restore the data base manually as well as setting the jobs and Maintenance Plans.
  • Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery. Used the DMVS, DMFS, Stored Procedures, Triggers and Functions for the instant analysis.
  • Monitoring of database size and disk space in Production, Staging & Development environments.
  • Maintain High Availability Solutions using Log shipping with SQL Server 2008 R2.

Confidential

SQL Developer / DBA

Responsibilities:

  • Creating and securing user logins with appropriate roles.
  • Created databases and specified automatic growth options.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Experience in implementing Disaster Recovery and High Availability concepts like Native Log Clustering, Log Shipping, Mirroring and Replication.
  • Used native tools Database Tuning Advisor, Profiler and Activity Monitor.
  • Experienced with Point-in-Time Recovery and Restored Database from backup
  • Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
  • Developed stored procedures, functions, triggers in T-SQL and batch scripts.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
  • Involved in day-today database maintenance operations. Maintaining the backup-restore jobs.
  • Created objects such as user-defined functions, tables, databases, indexes (clustered and non-clustered), stored procedures, views, and triggers;
  • Scheduled agent jobs for database backup and windows task to clean up the file system.
  • Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Used the DMV and DMF for the performance data collection and monitoring.
  • Used BULK INSERT to import the data from flat files using SSIS packages.
  • Responsible for keeping system and databases up-to-date making necessary changes.

Hire Now