We provide IT Staff Augmentation Services!

Sr Database Developer/analyst Resume

Somerville, NJ

SUMMARY:

  • Senior SQL Server Developer with over ten years of experience in SQL Server 2016/2014/2012/2008/2005 database development, database troubleshooting, performance tuning, database design and ETL design.
  • Currently working at Confidential Insurance on development and support of SQL Server databases.
  • ETL development and administration, database design performance tuning, etc. for multiple SQL server database servers.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2016,2014, 2012/2008R 2/ 2008/2005/2000 , MySQL 5.8, Sybase 10/11, Oracle 11G

OS: Windows

Tool: Crystal Reports 12.0,Python 3.6,Cassendra 3.10,DTS, SSIS, SSRS, Ms Azure, ASP, VB, COM, .NET, Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, Somerville, NJ

Sr Database Developer/Analyst

Responsibilities:

  • Collaborated with system architects, design analysts to understand business or industry requirements.
  • Partnering with IT to ensure system integration and approach data loads, governance, and logic.
  • Developing and installing appropriate levels of controls per interim data loads, and also focus on long term systems approach.
  • Focus on specific issues / data challenges unique to each BU while ensuring appropriate steps to drive harmonization.
  • Collaborate with Data Integrity Manager and IT product owner to ensure comprehensive and aligned approach to IT roadmap per additional systems (i.e. CRM).
  • Designing multiple SSIS packages for retrieving data from heterogeneous systems.
  • Creating and maintaining upload scripts to a hierarchical database as part of a data migration using SSIS.
  • Creating stored procedure to imports internal XML feeds into a SQL Server 2005 tables.
  • Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).

Confidential, NJ

Senior SQL server Developer

Responsibilities:

  • Hands - on experience in Azure Cloud Services (PaaS & IaaS)
  • Azure Data Factory to create a pipeline to move data from your local server up to AzureStorage.
  • Experience working as a DEVOPS Automation Engineer for database deployment
  • Experience in designing ETL for data movement between excel, flat file, RDBMS like Oracle, DB2 and SQL Server using Bulk Insert, BCP utility, DTS and a variety of SSIS(ispac) packages including custom transformations for a wide range of business requirements
  • Extracted data from internal data warehouse system to SSRS
  • Created reports in SSRS
  • Modified SP's and formulated basic coding and scripting to be utilized for reports
  • Analyzed data models, data relationships, and dependencies for greatest optimization
  • Designed and developed stored procedures, queries and views necessary to support SSRS reports
  • Performed functional and performance QA testing
  • Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Conduct code walkthroughs and review peer code and documentation.
  • Build efficient SSIS packages for processing fact and dimension tables
  • Created system for capturing, reporting, and correcting error data.
  • Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
  • Provide on-call support to production system to resolve any issues.
  • Gather requirements and design of data warehouse and data mart entities.
  • Perform data validations and data cleansing
  • Good understanding of MS-SQL Server database model and infrastructure; about tables, views, stored procedures, functions, keys, indexes, constraints, triggers, database replication, as well as SQL Server Agent (Jobs).
  • Capture audit information during all phases of the ETL process.
  • Responsible for deployment of packages and database projects
  • Preparing and providing database development requirement specifications to SQL Server database developer
  • Analyzes and generation of all tables and index statistics -Monitoring and resolving blocking and dead lock issues
  • Create indexes to achieve optimum response time for time consuming quries and reports. understanding of Software Development Life Cycle Documentation on sharepoint
  • Documentation management in sharepoint

Environment: SQL Server 2017, 2016, 2014, 2012, AlwaysOn, MS Azure, ERwin, SSIS, PowerBI, VSTS, Windows Server 2012

Confidential, Murray Hill, NJ

Sr. SQL Server Developer

Responsibilities:

  • Working as Primary SQL Server Developer in SQL server 2014,2012 environments performed Devops work for continuous integration and continuous deployment using VSTS
  • Understanding of code version control using TFS
  • Involved in the conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design,development,Unit testing,
  • Proficient in scripting T-SQL queries, Ranking functions,Derived tables, common table expressions (CTEs),stored procedures, views, user defined functions (UDF), constraints & Database triggers.
  • Proficient in the use of majority of the SSIS transformations,Containers,Tasks,migration of data from various source DB' s like Sybase, Access, Excel, Flat File to SQL Server, package configurations,logging,checkpoints,master and child packages,packagedeployment,variables and expressions,error handling and troubleshooting.
  • Aanalyze SQL query execution plan to optimize performance
  • Wrote Powershell scripts for to automate database operations
  • Experience in developing and performance tuning of complex SQL quires on high volume of data.
  • Partitioning for large tables in SQL server databases to improve performance.
  • Design and develop ETL (SSIS) processes for Datamart to load data from other heterogeneous sources(Oracle, Excel, Flat Files)
  • Experienced in Database design, Coding, unit testing and Implementation.
  • Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions.
  • Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Normalization, Replication and Documentation.
  • Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent
  • Good knowledge in developing and designing reports through SSRS
  • Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.

Environment: SQL Server 2017, 2016, 2014, 2012, 2008R 2/ 2008/2005/2000 , AlwaysOn, MySQL, MS Azure, ERwin, SSIS, PowerBI, VSTS, Git, Python, OS Windows Server 2008/2003, Redhat Linux

Confidential, NJ

Senior SQL server Developer

Responsibilities:

  • Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.
  • Effective designing of databases including: logical & physical data design, tables, normalization techniques, relationships, primary & foreign keys, and data types,
  • Invoved in Database Design of data mart.
  • Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
  • Contributed in creating ETL designs and provided end users an easy accession to data marts.
  • Troubleshot and resolved data models issues and formulated reports
  • Tested, adjusted and monitored alterations in designs using ERWIN tool.
  • Maintained data marts up-to-date and in accordance with company’s requirements and practices.
  • Documented data discovery, designs, patterns and mining projects.
  • Develop reports using SQL server reporting services and utilizing SQL queries and stored procedures.
  • Performance tuning for slow running queries
  • Follow SDLC, Change Control Management of the daily deployment of database code to UAT and production environment.
  • Extensive experience writing and performance tuning of T-SQL queries
  • SQL Development - ability to write and troubleshoot SQL Code and design ( stored procedures, functions, views, triggers, indexes, constraints )
  • Manage Indexes and statistics to improve performance and storage requirements.
  • Establish SQL coding standards, naming conventions, & data access policies.
  • Create report using crystal reports tool
  • Document company's database environment, processes, & procedures

Environment: SQL Server 2014, 2012, 2008R 2/ 2008/2005/2000 , Oracle 10G/11G, MySQL, ERwin, SSIS/DTSCassandra, OS Windows Server 2008/2003, Redhat Linux

Confidential, Radnor, PA

Senior SQL server Developer

Responsibilities:

  • Collaborated with system architects, design analysts to understand business or industry requirements.
  • Designing multiple SSIS packages for retrieving data from heterogeneous systems.
  • Creating and maintaining upload scripts to a hierarchical database as part of a data migration using SSIS.
  • Creating stored procedure to imports internal XML feeds into a SQL Server 2005 tables.
  • Performance tuning of high volume OLTP databases and SQL queries using large tables (> 50 million rows).
  • Resolved blocking and deadlocking issues in concurrent queries.
  • Database modeling, Database architecture and normalization techniques.
  • Deployment of Microsoft standard maintenance jobs for optimization of databases like re-indexing, index defrags, updates statistics.
  • Performance tuning and optimization of SQL Server database and quires.
  • Implemented table partitioning to improve performance and data management.
  • Developed SSIS package to refresh data from production.

Technology/Software: SQL Server 2008R 2/ 2008/2005/2000 , ERwin, SSIS, SSRS, TSQL, XML, OS Windows Server 2008/2003, Linux, Idera SQL Diagnostic Tool, MySQL

Confidential

Senior SQL Server Database

Responsibilities:

  • Database administration activities as an on call production support DBA for SQL Server databases for EASM supported applications like Estore. Created ER data models for product and pricing data.
  • Designed databases to support business applications, ensuring system scalability, security, performance and reliability.
  • Developed data models for applications, metadata tables, views or related database structures.
  • Designed and developed scripts to refresh selective data from production to development, QA and production support environments.
  • Involved in resolving the blocking and deadlocking issues and performance improvement using index tuning and other techniques.
  • Performed capacity planning and disk configurations for new hardware infrastructure.
  • Database modeling, database architecture and capacity planning and normalization techniques.
  • Code development and optimization (optimizing SQL queries). SSIS development and troubleshooting for data load.
  • Worked in SSRS administration and report creation. Performance test using tools like SQL profiler or server side traces.
  • Implemented table partitioning to improve performance and data management.

Environment: SQL Server 2008R 2/ 2008/2005/2000 , SSIS/DTS, TSQL, OS Windows Server 2008/2003, Idera SQL Diagnostic Tool

Confidential

Production Database Support - SQL Server - 2008, 2005, 2000 DBA Developer

Responsibilities:

  • Development and support for data warehousing in SQL server database system.
  • Designing fact and dimension tables for data warehouse database.
  • Creating SSIS packages to load data from OLTP database into data warehouse database.
  • Database administration activities as an on call production support DBA for SQL Server and part of RITS DBA account managers’ team.
  • On boarding new servers from different BUITS as per the RITS standard.
  • Handling SQL 2008/2005/2000 Installations (Cluster and Standalone).
  • Involved in installing SQL server single instance and multi instance clusters with active/active or active/passive configuration.
  • Migration from SQL 2000/2005 to SQL 2008.
  • Backup, restoration and recovery in different scenarios.
  • SQL server optimization job scheduling and maintenance.
  • Partitioning for large tables in SQL server databases.
  • Maintaining database documentation at team site.
  • Part of tier3 team and account manager for tier1 offshore team (PSITOPS).

Environment: SQL Servers 2008/2005/2000 , SSIS/DTS, TSQL, OS Windows Server 2008/2003, LiteSpeed

Confidential

SQL Server - 2005, 2000 DBA Developer

Responsibilities:

  • Database development activities as Production Database support for SQL Server 2005/2000.
  • Create Stored procedures, triggers, views and functions. Wrote complex queries to create reports.
  • Creating performance tests using SQL profiler (client side and server side traces).
  • SQL server 2005 installation (including integration and analysis services).
  • Database Design: Forward and Reverse engineering of ERD and Schema.
  • Backup, restoration and recovery in different scenario.
  • Managing user creations, assigning roles to SQL databases.
  • Requirement analysis and capacity planning for database designing, maintenance, update application schema structure/data models/ERDs and relations between objects as per requirement analysis using Erwin.
  • Installation of SQL server 2000\2005, applying service packs and hot fixes.
  • Development of DTS and SSIS packages, migration from DTS (SQL 2000) to SSIS (SQL 2005).
  • Administrator for Hyperion Essbase application. Developing reports using Hyperion Essbase.

Environment: SQL Servers 2005/2000/7/6.5 , SSIS/DTS, SQL, TSQL, ERwin, MySQL 5.0, Sybase 10/11, Windows

Confidential

SQL Server - 2000 Database Support

Responsibilities:

  • Installation of SQL server binaries, service packs and hot fixes.
  • Maintaining DTS packages, SQL server agent jobs and performance tuning.
  • Backup, restoration and recovery in different scenario.
  • Managing user creations, assigning roles to SQL Databases.
  • Server side and client side DB trace to monitor the activities on the database server.
  • Capacity planning for new servers.

Environment: SQL Server 2000, ERwin, DTS, SQL, TSQL, Windows

Confidential

SQL Server DBA

Responsibilities:

  • Wrote stored procedures in SQL Server Using TSQL.
  • Performance tuning. Database backup and restore.
  • SQL 2000 log shipping and replication.
  • Installation of components in MTS.

Environment: SQL Server 2000, ASP, VB, COM, MTS, Windows

Hire Now