We provide IT Staff Augmentation Services!

Sr. Data Engineer Resume

2.00/5 (Submit Your Rating)

Redmond, WA

SUMMARY

  • Over 9 years of experience in client - server Application, system support & Administration of SQL server databases using T-SQL and Power shell for Windows Server Platforms
  • Extensively worked on System analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member
  • Administer SQL Server 2005/2008/2008 r2/2012 always on cluster, Multi-failover subnet, SQL Virtualization, Server configuration on windows 2000/2003/2008 servers
  • Did Database and Application monitoring, database security, replication, Job automation and Backup- restore maintenance
  • Solid experience on SQL Server HA & DR solutions; Log shipping, database mirror and SQL Server fail over clustering
  • Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.
  • Experience in Creating SSIS package development and implementation for different tasks.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS
  • Extensive experience developing Integration Service Packages, SSRS and Stored Procedures and Triggers for business logic implementation.
  • Extensively work on Power shell scripts for monitoring windows services & SQL database health events and monitoring
  • Configure SCOM, created monitoring events, enabled the triggers for windows & SQL Server monitoring
  • Troubleshoot TFS WIT field mappings, Warehouse & cube processing. Configure and troubleshoot the cluster failover for TFS application and Data tiers
  • Setting up Windows Load Balancer, Configure IIS and bindings, configuring logs and FREB settings for application troubleshooting.
  • Follow ITIL process and change management systems and actively work for root cause analysis
  • Expertise on working in Production Support team and providing support on 24x7 basis.

TECHNICAL SKILLS

Database Modeling: Logical and Physical data base design for both transactional and decision-support systems using ER-Win.

SQL backups: Redgate

Database Tools: SQL Profiler, DTA, Data Transformation Services (DTS), SSIS, Upgrade Wizard, Query Builder, Jobs and Task creation and scheduling, BcP, Bulk Insert, XML, OLEDB, ODBC SQL Management Studio, SSRS

Databases: Oracle (10g/9i/8i), SQL Server 2000/20 and DB2

Utilities & Tools: SQL* Plus, T-SQL, SSIS, SQL* Loader, Tivoli Monitoring and Lumigent Audit tool

Operating System: Win XP, Win 2003/2008/2012

GUIs & Languages: .NET, PL/SQL, XML, HTML, Oracle Client, Visual Basic, Visual Studio

Modeling Tool: Erwin 3.5/4.1/7.0 and ER Studio

Version Control: VSS

Deployment Tools: Octopus & AutoPilot

PROFESSIONAL EXPERIENCE

Confidential, Redmond WA

Sr. Data Engineer

Responsibilities:

  • Performed Requirement gathering & analysis from the client side and technology department
  • Organized enterprise metadata repository using database
  • Data Standardization and de-normalization to ensure enterprise naming convention
  • Enforcing data Quality rules to upstream source using different tools
  • Conducted UAT, regression testing in the production environment
  • Maintained Data consistency and database integrity.
  • Performed numerous data extraction requests using web store, data migration between DC’s
  • Monitor server and health script for database and alerting. Create and generate daily health reports for space as well as sql long run time sessions
  • Setup monitoring for cluster owning the services, and AG health.
  • Automate the windows IPaks and patch installers. wrote script for cluster & AG health monitoring using power shell
  • Work with SCOM Management Packs for custom event monitoring
  • Deploy SSRS reports, build and deploy SSIS packages for ETL process
  • Configure RAID technology for SQL and use HP Array tool
  • Troubleshoot Replication and provide support
  • Did data migrations, support during data center movement. Install, configure SQL server 2008/2008R2/2012 always on cluster,
  • SQL Server fail over Clustering, Configure cluster and quorum configurations
  • Work on HA: Log Shipping, Mirroring.
  • Wrote SQL queries using derived tables and joins to extract data from the database.
  • Wrote PowerShell script for data growth for RISK monitoring, analyses the trend for future data growth

Environment: Windows Server 2003/2008/2012 , .NET Framework 3.5, SCOM, Octopus, SQL Server 2005/2008r2/2012, T-SQL, Webstore, Big Data, Hadoop, hive-SQL, ETL and SQL profiler

Confidential, Redmond WA.

Sr. System engineer/DBA

Responsibilities:

  • Interact with Dev team to fix the bugs and business users for feature releases and deliver the deployments
  • Setup and upgraded TFS DT servers SQL 2012 Always On HA, DR for Multi-site Failover
  • Create SharePoint sites, roles and provide the appropriate permissions for TFS integration
  • Problem management and provide solutions and knowledge base systems through documentation
  • Deploy SSRS reports, and configure subscriptions.
  • Involved in ETL Architecture, Developing Source to target data mapping (STDM) document defining transformation logic
  • Involved in Report writing according to business requirment using SSRS.
  • Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
  • Setup monitoring for cluster owning the services, and AG health
  • Work with IIS site configuration and bindings. Map SSL certificates and bindings.
  • Work with Management Packs for custom event for SCOM monitoring
  • Trouble shoot with tickets and track with Bug management to track the problem management
  • Support for cubes, objects, tables using (SSAS) report design for customer charging history data.
  • Work with PowerShell scripts for sever firewalls and remote app, windows updates
  • Use CmdLets for troubleshooting windows and cluster events, gather errors logs and send alerts

Environment: Windows Server 2003/2008/2012 , SQL 2014, VM,TFS Version control SAN, iScsi .NET Framework 3.5, SCOM, Octopus and ITIL

Confidential, Redmond WA.

Sr. Database Engineer

Responsibilities:

  • Develop, build and Deploy custom Applications with continues support for end users
  • Prepare and Maintain solutions for repeated the Live site issues and implement change management
  • Interact with Program manger and business users for feature releases and deliver the deployments
  • Problem management and provide solutions and knowledge base systems through documentation
  • Deploy SSRS reports, build and deploy SSIS packages for ETL process
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
  • Troubleshoot Replication and provide support
  • Monitoring and troubleshooting database performance by Rebuild Indexes, update statistics
  • Provide 24*7 production support for all database applications including on-call on rotational basis
  • Work in a team-oriented, collaborative environment
  • Good written, oral communication and documentation skills
  • Monitoring the health for SQL, check firewalls, and report the error logs and events
  • Configure sites, applications and perform Application failover, drain-stop, configure cluster services

Environment: Windows Server 2003/2008/2012 , RAID, SAN, iScsi .NET Framework 3.5, SCOM, Octopus, SQL Server 2005/2008r2/2012

Confidential, Burbank CA.

Sr. Support engineer

Responsibilities:

  • Manage, monitor maintain application servers and Database servers and exchange servers
  • Upgrade the systems and custom applications r2/2012, SSIS configuration and SSRS package deployment
  • SQL server performance tuning; Instance tuning for memory, Query tuning
  • Design, implement shared clusters, Deploy websites and security setup. Support admin MS SharePoint servers
  • Did data migrations, support during data center movement. Install, configure SQL server 2008/2008R2/2012 always on cluster, SQL Server fail over Clustering, Log Shipping, Mirroring.
  • Configure & support for SQL virtualization, SAN setup, ISCSI connectivity & RAID technology.
  • Set up server and database level security; Database encryption & security policy settings.
  • Worked with vendor systems in the design of applications, physical databases and schema design
  • Responsible and implement application performance tools, deploy out of box products and documentation
  • Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g.
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Involved in Data Integration for the various application modules; implemented cost center validation.
  • SQL virtualization, upgrade from sql on ESX virtual guests
  • Configure & support for SQL virtualization, SAN setup, RAID SETUP & RAID technology
  • Support webservers, file servers and exchange servers for the enterprise applications
  • Set up and administer Transactional replication
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Worked on logical and physical data base modeling with UML and ERWIN tools
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Ensured critical databases audited properly for DDL and other login activities

Environment: Windows Server 2003/2008, ESX hosts, SAN, iScsi .NET Framework 3.5, HP storage works v5.2, Tivoli 6.5.1, SQL Server 2000/2005/2008 r2/2012,Oracle 10g

Confidential, Pittsburgh, PA

SQL Server support Engineer

Responsibilities:

  • SQL 2008 up-gradation: Database restoration, server properties settings.
  • Perform file group backup, Scheduling, Maintenance and Disaster Recovery planning for SQL
  • SQL server report server configuration, setup security and roles
  • Bulk Insert and loading data files (.txt, .xls, .xml format) which comes from various legacy systems.
  • Expertise in creating Jobs, scheduling & running jobs and troubleshooting the failed jobs.
  • Modified SSIS packages for deployments to load data from different source files to SQL Server
  • Configure pull subscription for Transactional queue updated replication
  • Used SQL Profiler, SQL Server agent, and Execution plans as part of troubleshooting and performance tuning.
  • Up gradation from SQL 2000 to SQL 2005
  • Develop plans and manage and execute complex technical efforts
  • Perform DTS packages, perform Link Servers, work with T-SQL and write Stored Procedures
  • Deployed and managed reports through SQL Server Reporting Services (SSRS).
  • Develop Documentation for all Databases

Environment: Confidential Windows Server 2000/2003, Confidential SQL Server 2000/2005/2008 , Confidential SQL Server Reporting Services (SSRS), Confidential SQL Server Integration Services (SSIS), XML, SQL Server Business Intelligence Development Studio.

Confidential, Mt. laurel NJ

Sr. SQL Dba/Production support

Responsibilities:

  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Maintained cluster servers to provide high availability.
  • Set up database backup and recovery strategies.
  • Worked with development teams in the design of physical databases
  • Troubleshoot the Queue updated transactional replication conflicts
  • Provided technical support to internal developers and external clients
  • Involved in performing Extraction, Transformation and Loading using DTS.
  • Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
  • Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility
  • Development and implementation of Backup and Recovery strategies
  • Support for cubes, objects, tables using (SSAS) report design for customer charging history data.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Planned a complete backup on the database and restored database from disaster recovery..
  • Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.

Environment: SQL Server 2000/2005, SSRS, Oracle9i, Windows Server 2003, ASP.NET, JavaScript, XML.

Confidential, Lawrenceville, GA

Sr.SQL Server Developer/DBA

Responsibilities:

  • Installation and configuration of SQL Server 2005 on windows environment
  • Created Stored Procedures, Triggers, Views and Functions for the Application.
  • To design the security for the SQL Server and for individual databases.
  • Provided the detailed documentation of database structure and source code to Application Developers.
  • Created clustered and non-clustered index data structures on database objects.
  • Monitored and modified Performance using execution plans and index tuning.
  • Monitoring SQL server performance using Profiler to find performance and dead locks.
  • Analyze long running using SQL Server Profiler and tune them to optimize application and system performance.
  • Migrated data from legacy Databases in Sql 2000 to Sql server 2005 using SSIS.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases

Environment: SQL Server2005, MS Analysis Services (SSAS), Business Objects, Erwin 4.5, SQL Server Integration Services (SSIS), Transact-SQL, SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Excel, .Net, XML, Windows XP

We'd love your feedback!