SUMMARY

• MCTS on SQL server 2016\2019 wif over 13 years in teh Information Technology industry.
• AWS RDS Cloud, AZURE, MYSQL are used Confidential different opportunities and successfully helped in completing tasks
• Used Terraform and Jenkins to perform cloud migration and to create apps on OLTP systems. Used AWS services such as Elastic Cache and Aurora to adjust memory requirement.
• Used Profiler/XEvent and identified which event is effected during teh data transaction.
• Worked wif Information Technology, Banking, commercial, Gaming and Finance environmentExperience wif Software Development Life Cycle (SDLC) and AGILE project development methodologies involving sprints.
• Extensive experience wif data modeling, dimensional modeling, logical, UML and physical database design.
• Extensively worked in OLTP environment dat includes production (24x7), QA and development databases SQL Server.
• Strong Experience in Backup, Recovery strategy and Database Refreshes.
• Extensive experience in writing and debugging Complex Stored procedures, cursors, triggers, views and user - defined functions.
• Good understanding of Microsoft Reporting Service (SSRS) POWERBI, TABLEAU wif Report authoring, Report management, Report delivery and Report security.
• Performed ETL (Extract, Transform, and Load) using MS SQL Server 2016 SSIS, MS SQL 2016\2019 SSIS. Automated maintenance tasks and business processes, executing scripts, launching SSAS processes, submitting data mining queries, MDX Queries and processing/manipulating XMLA files. Used XMLA as teh protocol to communicate wif different front end tools.
• Installed, configured and maintained SSRS server and created Canned Reports and Ad-Hoc Reports
• Experience in using Macros in EXCEL using VB script and extracting DATA to Database
• Good understanding of ACID properties, RDBMS, Normalization /De-normalization, Normal Form and database modeling.
• Generated, Developed and Scheduled variety of Reports like List, Matrix, and Chart and Sub Reports etc. and Standardized company reports by implementing SQL Server 2016 Reporting Services (SSRS).
• Extensively worked and had good noledge on Integration and Reporting services and good experience in data migration from Oracle/Access/Excel sheets to SQL Server 2016/2019
• Experience in using different Transformation tools like DTS packages, BCP, and BULKINSERT, familiarity wif SSIS and SSRS.
• Successfully designed logical and physical database models using ERWIN data modeler; designed initial database migration plans and procedures for migrating data.
• Experience and outstanding noledge of high availability and SQL Server clustering.
• Proficient wif SQL Enterprise manager, SQL Query analyzer.
• Good Knowledge on Microsoft Office SharePoint Server.
• Experience in different team projects wif good project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Motivated Team Player who works well independently and in a team environment and can learn new concepts.
• Good Business and System Analysis skills to understand teh requirements and design application to accomplish teh business needs.

TECHNICAL SKILLS

Operating Systems: Windows 2008 server, Windows 2012 server, Windows 2012, Windows 10, VMWARE

RDBMS: SQL Server 2016/2019, MS Access, Oracle 10i/10g

Open-Source Databases: MySQL, PostgreSQL, MongoDB

Reporting Tools: MS Reporting Services, Crystal Reports XI

SQL Server Tools: Enterprise Manager, Management Studio, Surface Area Configuration, Configuration Manager, Query Analyzer, Profiler, SQL Server Agent, Database Engine Tuning Advisor, Performance Monitor, SSAS

ETL Tools: SSIS, DTS, Stored Procedure, T-SQL, Always On

Languages: VB.Net, ASP.Net, C#.Net, HTML, XML, VBSCRIPT, JAVASCRIPT, JAVA, POWERSHELL

WEB Services & Interfaces: WCF, ASMX, WPF/Silver light, and SOAP/XML, AWS Cloud

Other Tools: Erwin, SQL Lite Speed, Quest Central, Log Explorer, Microsoft Visual Studio 2016/2019, MS Visual Source Safe, Microsoft Office, MOSS. Terraform, Jenkins, Azure

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Senior Database Administrator/Power BI Developer

Responsibilities:

• Installed, configured, maintained, and upgraded from SQL Server 2008 to SQL Server 2016 including SSIS packages, database instances, reporting services, and Power BI (business intelligence) reporting and MYSQL under AZURE environment wif AWS
• Worked as AWS RDS Cloud SQL Server DBA using key tools of Terraform and Jenkins for cloud migration of OLTP systems. Several AWS services such as Elastic Cache and Aurora was used to adjust memory requirements.
• Maintained Informatic and MYSQL as location servers. Used SSIS for ETL purposes
• Used PowerShell scripting and worked wif AWS Cloud Systems. Handled RDBMS and NoSQL for collecting data from various sources like XML and CSV files.
• Maintained monthly backups for teh snapshot reporting and monitored database performance issues based on queries by using SQL Profiler/XEvent.
• Deliver actionable feedback to business owners and development teams regarding SQL Server performance and scalability
• Resolved memory issues and created replications used Always On.
• Support audit compliance efforts by reporting on setup, configuration, and application data for .net applications
• Provide and monitor Instance and Database level access to users and applications.
• Apply industry standard security principles and best practices (e.g., principle of least privilege) based on application and SSMS user requirement.

Confidential, Las Vegas, NV

Data warehouse Engineer

Responsibilities:

• Installed and Configured SQL Server 2005 and also Upgraded teh existing database to SQL Server Installed and Configured SQL Server 2008 in Test Environment.
• Worked in a Control Environment & familiar wif change management process according to teh source
• Backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Maintaining both DEV and Test servers in sync wif PRODUCTION server by doing Database Refreshes.
• Worked on ETL for pulling Data from Heterogeneous Source ->ODS (operational Data store) ->Data staging-> IDS (Integrated Data store) ->Data staging-> Data mart (Repository).
• Also identified Operational Database, Transactional Database, OLTP and Data warehouse meant for Decision support systems (DSS)
• Maintained Informatic and MYSQL as location servers.
• Created SLA for restoring teh database during disaster recovery as per teh Business requirements.
• Implemented 2005 feature such as Data partitioning, Database mirroring, Db Snapshot.
• Involved in implementation of replications like Snapshot and Transactional.
• Scheduled and created Maintenance plans on databases. Also created automated jobs to do DBCC’s.
• Day- to - Day monitoring of teh event logs and server logs for troubleshooting.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans Set Statistics IO, Profiler and Execution Plans.
• Understood and used NO lock and Unpadlock to avoid deadlock
• Created teh Best Coding Practices Document for stored procedures & functions for teh Developers.
• Managing security, which includes monitoring and controlling database access by assigning permissions to database users. Created User-Defined database roles.
• Helping installation of Database to start from SQL server services and maintain teh job chain. Used
• Analysis Management Object (AMO) for automatic security management, partitioning etc.
• Coordinating wif users for downtime and maintain teh system 24X7 running.
• Place teh huge table/non-clustered index on teh separate file group to improve teh performance and understood teh problem resolving for Database suspect
• Used XML as teh protocol to communicate wif different application like CMS, pcs, etc. to manage transactions, performing batch operation, defining and identifying objects updating cells (tuple), backup and restoring teh database.
• Created Linked Servers between SQL server 2000 and 2005 servers & for migrating data from DB2 database to SQL databases using Open Query.
• Created SSIS Packages to migrate teh data from database to Text files. Also migrated DTS packages to SSIS packages.
• Involved in creating logical (ERD diagram) and physical model (TABLES, Views and their Relationship) of teh database using Erwin.
• Created Normalized and De-Normalized databases for OLTP and DSS Environment.

Environment: VMWARE, Windows 2008/2012 MS-SQL Server 2008/2012/2016 , SSIS, SSRS System Monitor/Performance Monitor, DB-2 SSIS, Performance Tuning, Clustering, MS Visual Studio 2005/2008, WCF, ASMX, WPF/Silver light, SOAP/XML Microsoft TEAM FOUNDATION SERVER.

Confidential, Dallas, TX

DBA\ Data warehouse developer

Responsibilities:

• Writing new stored procedures, functions and T-SQL queries and modifying existing ones as per new business requirements.
• Worked in a Control Environment & familiar wif change management process.
• Involved in creating logical and physical model of teh database using Erwin.
• Hands on experience and outstanding noledge of high availability SQL Server solutions, including Log shipping, Replication, Database Mirroring, DB snapshots, DB Partitioning and Clustering.
• Extensive experience in Capacity planning, Maintenance planning, Performance Tuning, Query Optimization and Database Consistency checks using DBCC Commands.
• Created Normalized and De-Normalized databases for OLTP and DSS Environment.
• Place teh huge table/non-clustered index on teh separate file group to improve teh performance.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS)
• Used SSRS to create Canned Reports, Customized Reports, On-Demand Reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Designing Cubes and Data models for Data Warehousing Applications.
• Performed OLTP and OLAP data analysis (MDX scripts, KPI) using SSAS cubes.
• Responsible for teh data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 20052008 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Services (SSAS).
• Used SSAS to develop multidimensional Cubes based on STAR and SNOWFLAKE SCHEMA and used MDX queries from teh cubes to get perspectives and KPIs
• Generated teh LSPT Proposal based on teh SSRS reports which planner/client TEMPhas selected. Designed teh UI (web interface) of teh application, along wif prototyping.
• Created a tree view application to view teh recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) AND Crystal reports reporting tools to schedule reports to be generated on predetermined time both in testing and real-time environment.
• Created and Used KPI (key performance Indicator) in SSAS
• Writing MACROS using VBScript to create table in EXCEL sheets for new ETL requirements
• Involved in multiple database connectors using OLEDB, ODBC etc.
• Created MSI package using windows tools and coordinated wif C# development team
• Transformed data from various data sources using OLE DB connection by creating various DTS packages/SSIS.
• Managing security, which includes monitoring and controlling database access by assigning permissions to database users. Created User-Defined database roles.

Environment: Windows 2003, MS-SQL Server 2008/2005/2000 , SSIS, SSRS, C# System scripting, Oracle 9i,10G DTS, Performance Tuning, Clustering, IIS, JAVA, HTML, ColdFusion, Visual Studio, Microsoft Visual source Safe.

Confidential, NJ

SQL Server Developer/Report Developer

Responsibilities:

• Rectifying and performance tune teh data feed process. Debug, Performance tune and enable teh DTS packages for error logging.
• Used Agile project development methodology.
• Writing MACROS using VBScript to create table in EXCEL sheets for new ETL requirements
• Created MSI package using windows tools and coordinated wif C# development team
• Writing stored procedures, user defined functions and T-SQL scripts as and when requested.
• Applying various release from time to time.
• Proper use of Indexes to enhance teh performance of individual queries for very fast and efficient reporting process.
• Tuned stored procedures by adding begin Tran and end Tran and try catch blocks for error handling.
• Installed, configured and maintained SSRS Server.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS) and Crystal reports 9
• Used SSRS to create Canned Reports, Customized Reports, On-Demand Reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Designed and developed teh STAR Schema dimensional model for teh Analytical layer. Created OLAP cubes, Dimensions and Facts wif Drill through functionality using UDM (unified Dimensional Model)
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Created & scheduled SSIS packages. Also Migrated SQL 2005SSIS packages to SSIS packages.
• Performances tune teh Stored Procedures, User Defined Functions and long running queries.
• Developed and Deployed reports/report model using SQL Server Reporting Services.
• Administrator tasks like managing users, roles, and profiles.
• Migration of databases from MS SQL 2000 to MS SQL 2008.
• Filtered bad data from legacy system by implementing constraints and triggers for data consistency.
• Administered Backup and recovery and administered Disk and Database Space.
• Used BCP Utility in Stored Procedures to generate Output Files in Text format.
• Analyzing teh profiler data from production for blocking/deadlocking happening on teh server, to find out long running, I/O expensive, CPU expensive and read/write expensive queries.

Environment: SQL Server 2005/2000, Oracle9i, Erwin, IIS, Java, HTML, ColdFusion, SSIS, SSRS, SSAS Crystal ReportsWindows 2003/2000, UNIX, Visual Studio, WCF, ASMX, C#, SOAP/XML