Sr. Data Engineer Resume
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
