SUMMARY

• 6+ years of IT experience in Database Administration, Design Development, and Support of MS SQL Server 2012/2008R2/2005/2000 in Production, Test, Development, and Cluster Server Environments
• 3+ years of IT experience in Data Design and Development on Microsoft SQL Server 2016/2014/2012/2008 R2, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS, and Data-warehousing
• Experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process, and Business Intelligence, expert in installation, configuration, and maintenance of MS SQL Server2008 R 2/2008/2005/2000 in stand-alone and clustered servers
• Upgraded and migrated from an earlier version of SQL Server to SQL Server 2016, SQL Server 2014, SQL Server 2012
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX
• Solid experience in creating SQL objects as Databases, tables, views, stored procedures, Indexes, Triggers, User-defined data types, cursors, and Functions. Handled 20+TB of data, solid experience in troubleshooting Database/data Issues
• Experience in T-SQL programming skills, proficient in writing & debugging Stored Procedures and Triggers
• Extensive experience in Migration from SQL on-premise to SQLFARM virtual environment
• Expertise in database Backup, Recovery, and Disaster recovery procedures (Log shipping, Mirroring, clustering, Replication)
• Experience in Performance Tuning for slow/long-running stored procedures and server-level tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL), PL/SQL, experience in writing, and debugging Stored Procedures and Triggers, expert in utilizing different Monitoring tools including third-party tools
• Maintained Database Authentication Modes, Creation of Users logins, Configuring Permissions, and assigning roles
• Experience in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services), and SSIS Packages from SQL Server
• Using Performance Monitor/SQL Profiler to solve Blocking, Dead Locks/Long-running queries, experience in setting Database E-mail for notifications, creating alerts to track scheduled jobs
• Experience in SQL Server Reporting Services (SSRS), the Supported team in resolving SQL Reporting services and T-SQL related issues, and Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and SubReports, and formatting them
• Experience in creating data models and deploying to Report manager for developing Ad-hoc reports, SCHEMA design and defining data warehouse fact table, cubes, dimensions, measures, developing and deploying the cubes using SSAS
• Hands-on Experience in ETL (Extracting, Transforming, and Loading) development using DTS and by using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
• Worked closely with management, applications development staff, and users on database solutions to business problems
• Defined and administered database standards, controls, procedures, and documented, Provided after hours and 24/7 Database Maintenance and Production Support
• Experience in working with remote teams, good team player, strong interpersonal, and communication skills combined with self-motivation, initiative, and the ability to think outside the box
• Ability to handle multiple tasks, Initiative, and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills, able to grasp quickly and master new concepts and technologies

TECHNICAL SKILLS

• SQL Server Database Administration, Development
• Oracle SQL, MySQL, SQL Server 2016, Teradata
• SQL Server 2008 R2 on premise to SQL Server 2016 SQL Farm
• Relational Databases, Client-Server Architecture, OLAP, OLTP
• SQL, T-SQL, Python, HTML, DHTML
• SSRS, Tableau, Spotfire
• SQL Server 2016, 2014, 2008 R2
• SSIS (SQL Server Integration Services), DTS
• Excel, SSAS
• SQL Query Analyzer, SQL Enterprise Manager, SSMS, SQL Server 2005, Query Editor, Reporting Server
• Teamwork/Collaboration, Communication
• Leadership

PROFESSIONAL EXPERIENCE

SQL Server DBA/SSIS Developer

Confidential - Memphis, TN

Responsibilities:

• Reviewing business requirements to analyze data sources and worked closely with business analysts to understand business objectives
• Installed, Configured and Maintained SQL Server 2008 R2, 2016 in development, test, and production environment
• Maintaining Server and database security including database encryption (TDE)
• Experience in using Business Intelligence tools (SSIS, SSAS, SSRS) in MS SQL Server 2016
• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements
• Developed and deployed different types of Reports using different sources like SQL Server, Oracle, Excel CSV files
• Configuring and Maintaining Replications, Log Shipping and Mirroring High availability
• Upgraded/Migrated SQL server instances/Databases from older version SQL Server 2008 R2 to SQL Server 2016
• Developing SQL/T-SQL queries, Stored Procedures, Functions, triggers, performed database, and performance tuning
• Provides database assistance and problem support to application developers, business analysts, and business users
• Provides technical assistance, mentoring staff for developing conceptual and logical database design and the physical database
• Help developers improve the performance of that query by tweaking it or modifying indexes
• Provides support in capacity planning, forecasting, and tuning. Develops performance/tuning evaluation reports
• Investigating and applying necessary SQL Server database service packs, Hotfixes and Security Patches
• Experience in Extracting, Transforming, and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS, and SSIS services
• Data Loading Experience in SQL Server 2016 using SSIS ETL and expert in developing packages in SSIS and DTS as required for the implementation
• Experience in developing SSIS packages to transfer data from OLTP to OLAP Databases with different types of control flow tasks, data flow transformations and deploying the packages to the Production server
• Experience in Designing, Creating, and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPIs, Hierarchies, and calculated measures for OLAP cubes
• Worked with Multi-Dimensional Expression (MDX) for querying, manipulating the multidimensional data stored in OLAP cubes
• Experience in the Reports generation by using Authoring and Managing Components of SSRS from both relational databases and OLAP Cubes
• Experience in generating on-demand and scheduled reports for business analysis using SQL Server Reporting Services (SSRS). Created Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports, and Cascaded reports in SSRS
• Data analysis and data migration by transferring them using SSIS
• Developed queries to extract data from new and existing relational database applications as needed
• Developed Maintenance plans for database monitoring. Scheduling jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alerts and notifications
• Expertise in Database Backup, Restore and Point-in-Time Recovery

SQL Server DBA

Confidential, IL

Responsibilities:

• Serve as support for Database Administration tasks including configuration management, backup/recovery, performance optimization, and space management
• Produced high-standard database solutions to meet stability, reliability, and performance metrics
• Perform database deployments and provide support for application releases
• Performed troubleshooting of database related issues during the upgrading and migration process
• Solved Issues related to Orphaned Users and Managed Logins, Users, Roles, and User permissions
• Performance tune and Optimize frequently used SQL Queries, Indexes, and Stored Procedures
• Assist developers with MS SQL Server issues and questions
• Interface with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems
• Design, develop, test, deploy and maintain database security and audit solutions
• Supported multiple concurrent projects enabling delivery efficiencies and technical resolution
• Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure
• Worked on Client/Server tools SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
• Configuring, tuning, and optimizing SQL Server 2012, administrator tasks managing users, roles, and permissions
• Performance testing on stored procedures, indexes, and triggers
• Involved in complete database design including conceptual, logical, and physical models. Modified existing databases to meet the unique needs and goals determined during the initial evaluation and planning process
• Creating DTS Packages for data import/export, scrubbing, and scheduled jobs for backups for SQL and Oracle Databases
• Data migration using bulk copy program and DTS from Oracle Databases and Flat files
• Created Database Maintenance Planner for the Performance of SQL Server includes Database Integrity Checks, Update Database Statistics, and Re-indexing
• Created Complex reports using SQL Server Reporting Services, Period reports, Demographic reports and Comparative Reports
• Created and maintained logical/physical data structures
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages. Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection
• Developing stored procedures, triggers, views, and adding/changing tables for data load, transformation, and data extraction
• Migrated and tested DTS packages to SQL Server 2012 Integration Services
• Developing Crystal Reports used to generate all daily, weekly, monthly, and quarterly Reports including current status
• Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.

ETL Developer

Confidential

Responsibilities:

• Created SSIS packages using control flow and data flow elements to improve the performance of the package run time and to unit test the developed packages as an ETL developer
• Worked on performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS
• Work on the ETL process using Microsoft SQL Server Integration Services (SSIS) to provide the data quality, data cleaning, business rule transformations, data loading, support the data loads and transformations for the iterative conversion project
• Involved in migration from SQL Server 2008R2 to Oracle databases using SSIS
• Created reports from OLAP, sub reports, bar charts, and matrix reports using SSRS
• Designed and developed the ETL data flow to populate the CER Cube Analysis Database using the SQL Server Integration Services (SSIS) 2008. Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting
• Extensively involved in the SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Designed Dimensional Modeling using SSIS Packages for End Users. Created Hierarchies in Dimensional Modeling. Defined appropriate measure groups and KPIs
• Developed the Data Flow in SSIS with all the respective sources (Stored procedures, tables, Excel sheets, etc.), transformation, and suitable destinations as per the requirement
• Developed packages using variables, expressions, functions, stored procedures, parameters Involved in Defining queries, writing complex queries in SQL involving tables, Open queries, Joins
• Deployed packages, scripts, tables, stored procedures from lower to higher environments in TFS
• Worked with all the transformations and control flow components in SSIS as SCD, Pivots, FTP, Lookups, OLE DB sources, OLE DB Command, ODBC sources, Script Task (using VB Script), Foreach Loop Containers, Sequence containers, etc., along with few other users designed transformations Regular Expressions
• Worked on creating Fact, Dimensions Tables with needed transformations, Stored procedure sources, and moving to various locations using the FTP task
• Designed, developed Monthly and Yearly reports for Accounting purpose to calculate revenue and sales analysis using SQL Reporting Services
• Created and maintained a Point of Sales system to track all the sales generated from various customers across the globe into one single warehouse system
• Involved in designing, developing, debugging and testing of packages, scheduling the SSIS packages, Jobs. Worked on creating and executing complex T-SQL queries using SQL Server Management studio for back end data validation testing.

SQL Developer

Confidential

Responsibilities:

• Managed to work concerning due dates. Notifying manager of any conflicts or issues related to timely delivery of work
• Assist client managers with the development of client work orders
• Prepare instructions for deploying the applications, including instructions for custom configuration needed on servers or client workstations
• Working with other senior database developers & management, Designing or developing databases and database solutions using MySQL, MSSQL, Oracle
• Responsible for performing SQL development and SSIS /SSAS/SSRS development
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Generated reports according to business requirements using reporting services 2008
• Involved in creating report models and applying row level security filters for report model
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS)
• Developed a High-level dashboard using SSRS 2008
• Created several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules. Also Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/file groups/Files/transaction logs
• Worked with other developers to facilitate the creation of high performing data-centric components and applications
• Review the designs, code, and test plans of other developers and provide recommendations for improvement or optimizations
• SQL Development - Writing Transact SQL, Improves performance of T-SQL stored procedures
• Deploying environments/applications fixes, patches, improvements
• High achievement record in-process quality improvement and efficient data solutions management in data-intensive applications
• Converts legacy database systems to new formats and structures. Design tables, stored procedures, views, functions, etc. to write applications that can provide data feeds to the web user interface
• Experienced in Data Modeling, Database design & well versed with Server best practices and hands-on experience in developing Stored Procedures/routines and Reports
• Implemented performance tuning especially tuning complex queries, procedure and indexing strategies, Data Import/Exports, Database Recovery/Backup