We provide IT Staff Augmentation Services!

Sr. Software Engineer ( Sql Server Bi And Dba) Resume

Seattle, WA

SUMMARY:

  • Around 13+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2017/2016/2014/2012 /2008/ R2/2005/2000 and Oracle 9i/10g/11g/12g, Oracle finance database.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
  • Expertise in T - SQL writing stored procedures, triggers and functions.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Worked on configuring SQL Server with minimum privileged access.
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Working knowledge in SSDT tools (Analysis Services (SSAS), Reporting Services (SSRS)) and Clustering.
  • Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
  • Worked on Replication and Log shipping for SQL Server High Availability
  • Having hands on experience in Database Mirroring, Replication. Knowledge on AlwaysON HA
  • Worked on 32 bits and 64 bits SQL Server and MSCS Configurations.
  • SQL Server SSDT\Business Intelligence Development projects expertise to create Data Tools projects like SSRS reports, SSIS packages and SSAS with OLAP.
  • Expert in creating data transformation services like SSIS, DTS.
  • Extensively worked on SSRS reports building various types of reports and ad-hoc models.
  • Having Experience on Data center servers and handling very large TB databases globally
  • Proficiency and expertise in Backup, Disaster recovery planning, High Availabilities and Security Management.
  • Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
  • Strong experience in mentoring team members and writing documentation.
  • Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
  • Outstanding logical & problem resolving skills. 24 X 7 Production Database on Call Support
  • Exposure to the new SQL Server 2017/2016/2014/2012, Oracle 9i/10g/11g/12g
  • In-depth troubleshooting and fixing production ETL/SSIS packages issues within timely manner.

TECHNICAL SKILLS:

Databases: MS SQL Server 2017/2016/2014/2012 /2008R2/2008, Oracle 9i/10g/11g/12g, MS Access 2007/2010/2013

Programming Languages: Visual Studio 2008/2010/2012/2013/2015/2017, C#, .NET & SQL, VBA.

Database Technologies/Systems: ODBC, Oracle 10g, Oracle 9i/10g/11g/12g, MS Access 2007/2010/2013, Confidential SQL Server 2008R 2/2012/2014/2016/2017, PL-SQL, Oracle SQL Loader, SQL Developer, SQL Plus, SSDT (SSRS, SSAS, SSIS), Data Warehousing, Data Mart. MySQL, WinSCP, PowerShell Scripts, IIS. XML, HTML, TCP/IP, SOAPUI.

Operating Systems: All Flavors of Windows (Windows server 2012(Data Center Version)/2008/2003WIN 10/8.1/8/7).

Web Technologies/Systems: ASP.NET, VBScript, Web services

PROFESSIONAL EXPERIENCE:

Sr. Software Engineer ( SQL Server BI and DBA)

Confidential

Responsibilities:

  • Prepared the Technical and Function specifications based on the project requirements.
  • Involved in re-design, re-code, and deploy new data extractions using ETL\SSIS, and Designed and produced documentation of data transformations for all extractions.
  • Wrote and executed complex T-SQL queries successfully used for backend data validation tests.
  • Developed the PL/SQL queries and Staging tables used by ETL\SSIS for data push from to Oracle (GERS).
  • Developed and modified the existing reports to DATA DRIVEN Subscription reports sent out to all kiosks and stakeholders daily which helped to balance sales orders, identify completed previous days sales and returns.
  • Implemented failure alerts using email tasks in SSIS which provides users status of current ETL processes.
  • Involved in developing C# codes, and .Net framework used in some transformations cleaned up bad data in ETL/SSIS packages.
  • Analyzed the Performance of a Cube by partitioning it
  • Scheduled Database full, differential and transactional log backups using Maintenance Plans.
  • Involved in Cube Partitioning, creating KPI, Actions and Perspective, refresh strategy and planning and Dimensional data modeling in SQL Server Analysis Services 2012\2016(SSAS) improved performances.
  • Designed logical/physical data models and defined primary key, foreign key in database diagram
  • Used DBCC commands to troubleshoot and fixed issues related to database consistency.
  • Created and deployed ETL/SSIS packages using Heterogeneous data sources (SQL Server, ORACLE, MySQL, .DAT, CSV, Flat Files, Excel, text, DREYK source files, XML files etc.) transforms and load data into target locations used daily by SSRS subscription reports generates budgets and forecasts.
  • Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
  • Setup processes executes PowerShell scripts daily to delete old backup files frees up and maintains server drive spaces, avoiding server breakdown.
  • Performed daily Extracts of data from huge source files from different data sources (Verizon SFTP, IBM Sterling, Costco SFTP) loaded to DataMart DFILL, Finance DW. These enabled various groups to perform their daily tasks.
  • Used ETL Processes to perform Conversion goals and objectives which include identifying data for processed sales, and validated historical sales available in Oracle retail sales (GERS) migrated data to WA DataMart, Osprey DWs used by various groups (Replenishment, Accounting and Finance teams).
  • Responsible for data analysis, daily data loads from Data feeds to DW tables.
  • Developed, modified, tuned many T-SQL queries which optimized data parsing required for mapping in tools\ applications such as ATOOL (Accounting Tool), MTOOL (Merchandising Tool).
  • Monitored, tuned, and Optimized long running SQL queries, stored procedures, functions and Indexes by using Query execution plans (actual and estimate) results in significant improve in execution performances over 80% and resolved blocking and deadlock issues.
  • Designed, monitored and scheduled ETL/SSIS processes feeding data from various sources used in Development\TEST destination for business rule implementation designs, tests, troubleshoots and resolve issues.
  • Scheduled SSRS reports sent out daily to all client’s kiosks, including the executives, up to 500 reports broken down into REGIONS (SW, NW, SE, NE and Military).
  • Redesigned and UPGRADED all the ETL processes from the existing legacy DTS\SSIS packages from 2005\2008\R2 into new versions of SSIS Packages 2012\2014\2016.
  • Setup environment variables in integration catalogues which protects and guard wrong data from been sent to production.

Environment: Confidential SQL Server 2008\R2\2012\2014\2016, Windows Server 2008, Windows Server 2012(Data Center Edition), Windows 8.1\10, Visual Studio 2008R2\2012\2013\2015, SQL Server SSDT 2012\2013\2015, Confidential Visio 2010, Oracle 9i\10g\11g\12g, PowerShell, WinSCP, SFTPs, PowerBI

Sr. Software Engineer

Confidential

Responsibilities:

  • Worked with business users, programmers, testing staff, and internal application developers to develop database requirements, test plans and database schemas and migrates\upgrade to newer SQL Server versions.
  • Extensively used embedded SQL in VBA front end.
  • Designed specifications/layouts for Data entry screens and reports provides aggregated values for specific fields
  • Created reports in Access and Excel 2010, 2013 and O365 provides correct commissions values for managers
  • Used Functions and Procedures in MS Access VBA modules executed as code for automated transferring of data between spreadsheets and work books.
  • Migrated MS Excel and MS Access applications from MS office 2007\2010 version to MS Office 2013 and O365 Version. Database conversion from MS Access 2007 to Access 2010
  • Resolved Production Support tickets for MS Access, MS Excel and SQL Server applications on daily basis. Performed trouble-shooting, designed and developed new MS Access databases and database modifications.
  • Securing the Database, managed user accounts and Access rights enabling users to perform necessary data processes and required outputs
  • Setup MS Access/Excel applications to run on centralized network location during regular server downtime as part of application side Risk Management consolidating and protecting all data imports.
  • Automated importing and cleaning of data from text files, csv and Excel into Access to upload in other applications. Used ADO/DAO to connect SQL Server and Oracle as Backend Database.
  • Data Modeling. Designed and developed tables and data-entry Forms for excel raw data file import
  • Created Access Reports using VBA and SQL. Created User Forms for the spreadsheets.
  • Handled optimization Issues related to linked objects from ODBC data sources ensured successful connections across platforms enabling Excel workbook\ spreadsheets real-time data updates
  • Migrated MS Access database to a robust Oracle 11g database and converting Forms, Reports, Procedures in Visual Basic 6.0.
  • Migrated Access Databases to SQL Server as backend keeping the front end in Access 2007/2010 for record aggregations and storage.
  • Defined functional and technical requirements, wrote test plans, best practices, trained users to test and use new and enhanced systems.
  • Consolidated Data of Spread Sheets. Import/Export of data between Excel to Access

Environment: MS Excel 2007/2010/2013 /O365, VBA, Oracle 9i/10g/11g, Visual Basic 6.0, MS Access 2007/2010/2013 , VBA, Windows 7/8.1/10, Confidential SQL Server 2008\R2\2012\2014\2016, Windows Server 2008/2012 (DataCenter version)

Sr. Software Engineer ( SQL Server BI and DBA)

Confidential, Seattle, WA

Responsibilities:

  • Performed database upgrades from older versions SQL Server 2008\R2 and 2012 to SQL Server 2016.
  • Interfaced with business analyst to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
  • Discussed requirements with cross functional departments and generated reports for different department, managers and executives as required.
  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Designed and developed ETL/SSIS Packages extracted data from sources such as MS Excel, Oracle (General Retail Sails), Oracle finance, SQL Server 2008R2\2012\2016, .DAT and Flat files successfully transformed and load to outlined target locations
  • Used various transformation components and tasks many ETL/SSIS processes and delivered expected output data to client.
  • Used check points, break points, event handlers and error handling to debug various ETL/SSIS, traced and captured code bugs and ensured the integrity of data during transformation.
  • Performed SQL query tunings and improved query execution performance and costs.
  • Created clustered, non-clustered indexes to optimize query performance using Confidential SQL Server 2008\R2\2012\2014\2016.
  • Translated requirements into physical database structures that integrate with existing or proposed database structures.
  • Responsible for making sure SSRS reports are scheduled and delivered in a timely manner
  • Performed multiple SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Performed ETL architecture enhancements to improve performances by creating temp\staging tables as IFACE tables before transformations and load to target tables.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Involved in scheduling, creating snapshots and data driven subscriptions for the reports using SSRS 2012\2016.
  • Involved in designing Parameterized Reports and generated Ad-Hoc reports per client requirements.
  • Managed SSRS report security and authorization on Report Manager.
  • Coordinated with eCommerce platform and front-end POS application (WA2GO) developers for implementing logic in stored procedures and functions at the database.
  • Strong experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic

Environment: Confidential SQL Server 2008\R2\2012\2014\2016, Windows Server 2008, Windows Server 2012(Data Center Edition), Windows 8.1\10, Visual Studio 2008R2\2012\2013\2015, SQL Server SSDT 2012\2013\2015, Confidential Visio 2010, Oracle 9i\10g\11g\12g, PowerShell, WinSCP, SFTPs

Sr. Software Engineer\Database Administrator

Confidential

Responsibilities:

  • Worked with the PMs & Project teams, created estimates and develop database solutions for project executions.
  • Intensive experience in translating business requirements to Database Objects.
  • Assisted apps development team with database activities. Ensured develop SQL code per documented design and coding guidelines. Developed data models & ensure databases comply with organizational\enterprise standards
  • Create, optimize, and maintain SQL queries that support application functionality and operational activities.
  • T-SQL and Oracle PL/SQL queries Development.
  • Worked with complex data models and object relational database mapping in SQL Server, produced complex reports as designed
  • Communicated and worked effectively with other groups to coordinate successful design, development, and testing efforts of assigned application components lead to successful release and pilots.
  • Expert experience in tuning T-SQL queries and optimized database performances.
  • Identified and resolved problems occurring in all database environments including performance related issues (database & SQL query) resolved chains of blockings and deadlocks
  • Performed SQL Server database upgrades to higher version and from 32bit to 64bit platform.
  • Upgraded the Oracle 9i databases to 10g including data guard provides licensing support by Oracle.
  • Created database objects like tables, views, custom views, procedures and packages in Oracle(GERS) using tools like Toad, Oracle SQL-Developer and SQL* plus implemented business sales rules in the system
  • Expert in constructing objects, Tables, Stored Procedures, Views, Functions, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations implemented business rule.
  • Expertise in creating Joins and Sub-Queries for complex queries involved multiple tables with significant optimized query performances
  • Strong Experience in writing advanced query concepts using having clause, group by optimized performances
  • Designed test strategies for performance testing and volume testing of PL/SQL solutions capturing long running processes
  • Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types.
  • Worked on Oracle SQL*Loader\SQL Developer to load data from flat files obtained from various facilities daily.
  • Designed, reviewed, and created database objects based on business requirements and physical constraints
  • Created and maintained SSIS packages to Extract, Transform and Load ETL user data and other data from OLTP to OLAP. Used SSIS For-Each loop to implement data updates from various sources to data warehouse.
  • Configured and deployed new Project based deployments in SSIS 2012. Deployed the Projects to Integration Services Catalog and managed the security, and created SQL Server Agent Jobs to schedule daily data transformation.
  • Created and Managed OLAP Cubes and created different KPIs to perform analysis based on business requirements. manage the performance of cubes by modifying measures and dimensions in SSAS 2012\2014 project designs.
  • Processed and maintained the SSAS cubes on a schedule directly in SQL Agent jobs through SSIS Analysis Services Process accounts.
  • Scheduled SQL Server Agent Jobs to monitor data transformation and database updates.
  • Identified fact tables and dimension tables, and created data marts for various subject areas as required.
  • Scheduled and monitored SSRS report subscription and deliveries such as Email Delivery and File Share Delivery daily as required.

Environment: Confidential SQL Server 2008\R2\2012\2014\2016, Windows Server 2008, Windows Server 2012(Data Center Edition), Windows 8.1\10, Visual Studio 2008R2\2012\2013\2015, SQL Server SSDT 2012\2013\2015, Confidential Visio 2010, Oracle 9i\10g\11g\12g, PowerShell, WinSCP, SFTPs

Software Engineer\Database Administrator

Confidential, Seattle, WA

Responsibilities:

  • Known for excellent troubleshooting skills - able to analyze code and engineer well-researched, cost-effective and responsive solutions
  • Problem solving capability peered with strong communication skills.
  • Exceptional ETL design/development knowledge.
  • Created SSIS packages that does incremental loads of new item data to Datamarts
  • Troubleshoot and fixed existing SSIS packages having some bleedings within the codes and loading incorrect item SKUs data to Datamarts
  • Developed PL SQL codes that run Dfill Reports in the Oracles 9i production (GERS) for client.
  • Created SQL Agent scheduled jobs that executes packages at set times
  • Troubleshoot and fixed failed SSIS package SQL agent scheduled jobs.
  • Fixed various SQL Server drive space issues
  • Created Linked Servers to SQL Servers and other database servers such as Oracle, Access
  • Created and Managed SQL Agent Jobs for maintenance of databases including (Full, diff, Tlog Backups/DBCC, file cleanups)
  • Created SQL Server logins and Users, assigned respective permissions based on the role access required to perform their daily tasks.
  • Developed and deployed to production ETL packages for transferring and transforming file data
  • Troubleshoot and fixed multiple clients SharePoint Site issues within short-time of notice.
  • Good skills of investigating and understanding of data flows and able to determine root cause of issues and getting issue resolved within short period of time.
  • Bug fixing and maintenance of the client site products.
  • Fixed bugs within legacy codes and support provided through ASP. NET, PL SQL, T-SQL, Confidential SQL Server, and Oracle 9i. Performed SharePoint Site version upgrade
  • Supported existing legacy system to provide newly created cases and insured they were available in the systems in parallel until legacy systems were retired.
  • Fueled additional revenue stream through responsive customer support, generating high amount of sales within first few weeks of new product release.
  • Collaborated in the development of in-house development of new monsoon CTO software interfaces.

Environment: C#.NET, Visual Studio, MySQL, Oracle 9i, ADO.NET, SQL Server 2008R2/2012/2014

Support Engineer

Confidential, Seattle, WA

Responsibilities:

  • Investigated issues requested by Bing Ads Account Managers to perform root cause analysis of the issue and provide long term resolution.
  • Experienced using Confidential Dynamic CRM as ticketing tool for issue logs and documentation
  • Executing SCOPE scripts in Visual Studio 2013 to pull monetization logs from Cosmos cluster environments
  • Create and execute SQL server queries in SQL server 2012 databases to pull customer data from backend based on the specified data requests (ad hoc data requests)
  • Provide customers assistance on how to implement Bing conversion codes and revenue tracking codes in source code of their web pages
  • Using Fiddler tool to troubleshoot behind the scene and run traces to determine TrackingID and\or RequestIDs on issues occurring when users experiencing problem while trying to perform their daily tasks in any of the tools such as Bing Ads UI, EVD tool (Editorial Verification Desktop), running reports, mosaic tool.
  • Created and written lesson learned documentation which are published as articles in e knowledge share resources
  • As a member of Yahoo V-team, was Support Engineer leading the call and performed brownbags presentations to the Yahoo AMs and Techs in multiple occasions.
  • Escalated issues as High Priority to the MOC engineering team. Created service alerts and sends out to the respective stakeholders DLs.
  • Troubleshooted XML\API SOAP Reports issues using Soap UI.
  • Creating LSRs and bugs using the Visual Studio Team Foundation Server (TFS) or Bugger.
  • Been night, weekend and holidays On-Call engineer.

Environment: Editorial Verification Desktop (EVD), Bing Ads UI, Confidential Dynamic CRM(Ticketing), IRT Tool, ad-inquiry tool, Soap tool, SQL Server 2012 DBs, log analyzer

Confidential, Redmond, WA

Incident Engineer \ SQL Server DBA, Redmond, WA

Responsibilities:

  • Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
  • Rebuilding /Monitoring the indexes at regular intervals for better performance.
  • Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
  • Good experience with Confidential TSQL, OLAP
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Installed, authored, and managed reports using SQL Server 2008\R2 Reporting Services.
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
  • Day-to-day administration of live\production SQL Servers.
  • Troubleshooting and resolving incident issues (such as mirroring, transaction log full on database, application health status and Web Sites) for large number of databases in production environments
  • Rebuild indexes at regular intervals for optimized performance
  • Index tuning and Database tuning on a regular interval on Production Databases.
  • Meet the SLA (Service Level Agreement) established.
  • Monitoring the server for High availability of the servers.
  • Solving the request raised by user support.
  • Troubleshooted and resolved alarms and failures for SQL jobs, mirroring, and replication agents, IIS, web page issues.
  • Smoke testing of SQL servers using GAST commands and web servers by URL tests.
  • Performing manual load balancing of servers.
  • Suppressed and un-suppressed of the production servers.

Environment: SQL Server 2005, 2008 and 2012,Windows 2000/2003/2008, SSRS,SSIS,SSAS, Performance Monitor, SCOM, Sitescope, VIPnet, iAdmin, UTS, IMC, iWatch, Tmf.

Confidential

System Analyst\ Database Administrator, Atlanta, GA

Responsibilities:

  • MS SQL Server Database Administration Experience working with SQL Server 2000, SQL Server 2005, and 2008.
  • Developed Business Analysis Applications and Ad-Hoc/Custom reports using SSRS 2000/2005.
  • Creating of cubes and packages with Visual Studio (SSIS, SSAS).
  • Detailed level knowledge of SQL Server internals, database design, T-SQL, database mirroring, log shipping, database Snapshots and backup/restore operations
  • Design, creation, configuration and support of Oracle & SQL Server databases.
  • Upgrade existing MS SQL Server software to newer versions and/or Service Pack Levels
  • Provide 24x7 on call support and problem resolution as necessary.
  • Performed production supports by troubleshoot and fixed database issues, performance monitoring/tuning, and capacity planning for Oracle and SQL Server.
  • Development & Test DBA for Oracle, SQL Server & MS Access.
  • Applied appropriate problem-solving methodologies to the analysis and develop solutions of client database system problems. Configuring and auditing MS SQL Server security.
  • Designed PL\SQL scripts to create temporary tables within a number of databases schemas.
  • Participated in planning, testing and performing major upgrade of SQL Server 2000 involving over 19 production databases. Plan for backup and recovery of database information
  • Create primary objects (tables, views, indexes) once application developers have designed an application.
  • Modify the database structure, as necessary, from information given by application developers.
  • SQL 2005\2008\R2 Server Performance Tuning, T-SQL Query Performance tuning

Environment: SQL Server 2000, 2005 and 2008, Oracle 10g &11g, SSRS,SSIS,SSAS.

Hire Now