SUMMARY:

• 9+ years of IT experience as SQL Server 2017/2016/2014/ /2005/2000, MONGODB, MYSQL & Oracle Production / Application DBA, PL\SQL\T - SQL & BI Developer, Power BI Developer, Teradata developer, Database Architect in e-merchant, educational, Oil & Gas, Automobile, IT Hardware & Software and Financial domains respectively.
• 3 years of IT experience as Cloud Engineer / AWS solution Architect in delivering cloud engagements, strategy, transition and transforming customers to cloud and adopting the cloud first model to build business applications
• Good knowledge on multiple clouds which include AWS, Azure.
• Expertise in architecting the design, scalability, high availability, (Disaster Recovery) DR Design on Cloud Infrastructures, Providing solutions based on a range of Cloud technologies and services.
• Sound knowledge on evaluating the technical assessment to modernize/migrate/move application to cloud, define the target state of application for the relevant cloud environments (IaaS, PaaS, SaaS; Private, Public Cloud), including business case.
• Proficiency in developing Cloud Security policies and strategies in par with the organization's compliance structure.
• Providing Risk Management and mitigation recommendations for projects in organization.
• Knowledge on architecting the application for AWS by using AWS services and resources and compare the different modernization options.
• Installed, configured and maintained standard and enterprise editions of SQL Server 2017/ 2016/ 2014/2012/2008 R 2/ 2008/2005/2000, MYSQL & ORACLE DATABASES
• Expertise with handling databases such as installation, configuration, monitoring on Physical, Vmware and Cloud environments
• Successfully upgraded SQL Server 2000 SQL Server 2005 SQL Server 2008/2008 R2 SQL Server 2012/2
• Expertise on database migrations between Oracle SQL Server SAP HANA database servers respectively.
• Managed, Monitored around 40,000 various databases of sizes between 100MB - 100TB and 20,000+ various database servers including SQL, ORACLE, SAP HANA servers in 24/7 environment
• Good experience in data backup and recovery using OPS Manager.
• Good knowledge on Mongo utilities (mongostat, mongotop, mongoperf, mongodump and mongorestore)
• Proven ability of providing production support for 24x7 on multiple databases
• Implemented, Configured and maintained Always ON, Clustering(Active/Passive), Replication(snapshot, Merge and Transactional), Log Shipping as HA & DR plans for SQL Server 2005/2008/ 2012/2
• Hosted SQL Databases on Microsoft Azure, AWS RDS
• Developed and maintained various complex T-SQL, Powershell scripts for various DBA related tasks and automated SQL Installations
• Managed developed and troubleshooting DTS/SSIS packages, SSRS reports & SSAS Cubes and resolved complex issues using Performance Monitor, SQL Profiler and Dynamic Views.
• Migrating and Tuning SQL scripts, indexes, stored procedures and views Fine for production environments
• Designed ETL with SAP DataServices, SSI, RFC
• Worked on Procure to Pay SAP application.
• Experience in maintaining SAP BPC, SAP DW, SAP HANA and developing ETL packages with SAP data sources
• Experience in Linked Servers and linking different databases like MS Access, Oracle, Teradata, SAP HANA
• Hands on experience on setting up Maintenance plans, scheduling backups using sql native backup techniques, redgate backup tool, idera SQLDM, commvault backup tool
• Experience on Teradata SQL Assistant, BTEQ, ETL tools - Teradata Parallel Transporter, Fast Load, Multi Load, Tpump and Fast Export scripts and in reading, understanding and interpreting Teradata Explain Plans, Teradata Joins, Indexes, Statistics, Stored procedures, Triggers, macros Capacity Planning, and Performance tuning.
• Experience with LDAP, handling Active Directory data using SQL Server
• Experienced in writing C# code for Implementing ETL operations, developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of the products to various developments.
• Involved in Database Design, Data Modeling, Development, Programming, Implementation, ETL and Reporting in SQL Server 2000/20 /2014/2016
• Good knowledge of configuration management concepts, release management, changes management concepts, Industry standards and best practices.
• Developed and maintained databases for various custom applications and reports .NET and Java developers
• Experience in Data Warehousing, writing complex MDX queries, SSAS (Tabular & Multi-dimensional) for creating cubes, development of applications and building Data Marts, Operational Data Store (ODS), OLAP using MS SQL Server 2000/20 /2014/2016 , Reporting Services (SSRS), Integration Services (SSIS),Analysis Services (SSAS), OLAP Cubes, Star and Snow flake schema using DM tools like ERWIN, Visio, SQL Diagrams.

PROFESSIONAL EXPERIENCE:

Confidential, AUSTIN, TX

MSBI Developer /SQL Server, MONGO DB DBA/ Database Architect

• Worked directly with customers, analysts, business stakeholders, vendors, application developers, production teams and across functional units to identify business needs and discuss solution options.
• As a team lead, trained developers and DBA’s for the enterprise projects.
• 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.
• As a Solution Architect, responsible for business engagement, customer requirements, business communications, team management & delivery.
• Estimating AWS costs and identifying cost control mechanisms.
• Designing and implementing both the front-end and back-end systems that run on AWS on par with organization compliance and security policies.
• Designing and deploying scalable, highly available, and fault tolerant systems on AWS.
• Selecting the appropriate AWS service based on data, compute, database, or security requirements
• Implemented AWS Cloud Services EC2, VPC, Route53, S3, Dynamo DB, ELB, RDS, Elastic Beanstalk, Auto Scaling, SNS, SQS, Cloud Watch and Cloud Trail.
• Orchestrating and recreating the AWS Cloud Formation templates to create custom sized VPC, Subnets, NAT to ensure successful deployment of web applications and database templates.
• Configuring DNS (Route53), ELB, general networking principles, firewalls, route tables and route propagations
• Create and maintain SSL Security certificate management for enterprise, maintaining certificates across multiple SSL-providers, and integrating certificates into products such as nix, apache, tomcat, AWS-ELB.
• Managing AWS Infra and automation with CLI, API. Managing Data Centre Inbound and Outbound services
• Tuning Cloud Watch to screen assets, for example, EC2, CPU memory, Amazon RDS DB administrations, Dynamo DB.
• Created work flows for AWS Data pipe line jobs using AWS resources with defining activities, schedules and parameters.
• Configuring WAF and Amazon shield on the Amazon cloud front.
• Setting up AWS direct connect and monitoring private network connection between AWS and corporate data centre and other regions with network latency(China)
• Used Python Boto SDK for creating custom monitoring scripts to maintain tagging Standards for AWS resources
• Assisting client in AWS cloud strategy; defining workloads, IAM configuration standards, Glacier archiving standards.
• Lift and shift of an existing on-premises application to AWS.
• Ingress and egress of data to and from AWS.
• Identifying appropriate use of AWS architectural best practices.
• Introduced and Implemented Devops automation for the new builds using CI/CD tools (Jenkins/Ansible), CMP tool(Cloud aware), Patch Management(WSUS/Pulp) and reduced the build times significantly and helped to onboard the customers efficiently.
• Designed and developed multiple databases and application data flow along with ETL frameworks as a data architect.
• Designed Data Quality Service path along with data integrity checks for developers and testers.
• Involved in Capacity planning for various SQL databases related to multiple applications.
• Experience with RAID levels and SAN storage infrastructure
• Installed, configured, Maintained various editions of SQL Server 2017/ 2016/ 2014/2012/2008 using automation Windows Power Shell Scirpt on multiple servers including physical and VMWare environments
• Installed SQL Server 2017 on various Linux Operating Systems.
• Installed, Configured, maintained Always ON /Clustering/Log Shipping/ Database Mirroring/Replication as Disaster Recovery option for various databases using SQL Server 2016/ 2014/2012/2008 R2
• Hosted new built application SQL databases on Microsoft Azure & AWS RDS
• Installed, Configured, Maintained SQL Reporting & Analysis servers.
• Developed Complex queries using T-SQL cursors, SQL joins & stored procedures for generating database migration scripts.
• Migrated database from various SQL Versions and migrated from ORACLE SQL, SQL ORACLE, SAP HANA SQL
• Migrated databases, logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server /2014/2016 on Development, Testing Production Environments for various mission critical applications as part of end of life project.
• Enabled Contained databases on SQL 2012/2014/2016 for frequent database refreshes from Prod to Dev environments.
• Installed, configured, Maintained SAP HANA and migrated data from SQL to SAP HANA.
• Implemented of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers via native sql technique and third party tools such as Redgate backup, idera SQL DM, commvault backup tools.
• Installed, maintaining and monitoring Active/Passive SQL Server 2016/ 2014/2012/2008 clusters
• Changed service accounts on 400 plus SQL Servers and resolved multiple issues using T-SQL scripts
• Installed & managed databases related to Tripwire, SCCM 2012, BIT9, Quest Recovery Manager (RMAD), SCOM, Idera SQL DM, Idera SQL Safe, Idera SQL Secure, StealthIntercept, Migration Manager
• Developed automated scripts to monitor and fix issues related backups, SQL Jobs and other production issues.
• Maintained the Database refreshing till the end of cut over of the project as part of database migrations
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary using SQL Profiler and Index Tuning Wizard.
• Development of automated daily, weekly and monthly system maintenance tasks.
• Created jobs, alerts and monitor, activity logs, error logs to capture and fix any possible errors
• Created Linked Servers across various data sources including SQL Servers, Oracle by installing Oracle client.
• Handful of experience on Maintaining Data Governance for SQL Best Practices.
• Installed & Configured 10 TB size of Mongo DB.
• Configuring Sharding, monitoring, and identify the proper shard key Selection, Inserting large amounts of data Performing Security measures, backups and restore backups for Mongo DB
• Extensive experience in deploying, managing and developing MongoDB clusters. Architecture and capacity planning for clusters.
• Creation, configuration and monitoring Shards sets. Analysis of the data to be sharded, choosing a shard Key to distribute data evenly.
• Planned and implemented a project to add a new node to the Replica set and monitored the initial sync process .
• User Management - creating users, assigning roles, managing permissions for SQL Server, Mongo DB database server
• Maintained SAP HANA databases along with its security roles, developed ETL packages with SAP HANA data sources
• Maintained the Procure -to-pay SAP application and designed the data flow from the application to multiple databases like SAP HANA, SQL, ORACLE, MONGO DB.
• Developed complex databases, tables, Cluster/Non-Custer Index, Views, Unique/Check Constraints, Triggers, SQL Queries, Joins, sub-queries, correlated sub queries, Stored Procedures, functions, Joins, Constraints, DDL, DML and UDFs using T-SQL with best execution plan in Development and Production environment for SQL Server 2008/ 2012/2014/2016 for financial STOCKS.
• Designed and Built DataMart for Retirement Processing system for Schwab.
• Used CTEs for recursive functionality to bring the organization structures.
• Involved in complete SSIS lifecycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production) to import and export data from MS Excel, SQL Server 2008/2012/2014 , Flat files and various different sources.
• Created Power BI report Such as 'Daily Sales and order Report', 'Invoiced Sales Report', 'Daily Sales Report', 'Territory Performance Report'.
• Designed dashboards utilizing Power BI based on separate report listed above.
• Created KPIs utilizing calculated function and quick table function in tableau and DAX in Power BI.
• Optimized report data sets to reduce the report generation and rendering time in Power BI environment.
• Migrated and translate legacy reports into Power BI from SSRS environment.
• Designed dashboards and scorecards with power pivot for analytical decisions in Power BI desktop.
• Created Content pack for the Self-Service functionality for the user
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data Warehouse using Fore Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source, Slowly Changing Dimension, SQL SP’s and FTP, file system and more.
• Performed ETL mappings using MS SQL Server Integration Services 2008/ 2012/2014/2016 .
• Handled SSIS packages for Logging, error handling, complex transformations, Deployment and production support.
• Created Ad Hoc reports by building models in Report Builder using SSRS Model Designer and Report Builder 3.0
• Developed SSRS reports, ad-hoc Reports, Sub Reports, Linked Reports, Report Models and Drill down reports for Sales for the business in Agile project environment for Finance and Revenue Management teams
• SSRS report deployments to SharePoint 2010 custom libraries and involved in maintaining SharePoint site security.
• Developed Oracle PL/SQL procedures and Oracle packages
• Worked as part of Financial Systems Architecture & Reporting teams and developed SSAS 2012 tabular in-memory models.

Environment: EC2, Elastic beanstalk, ECS, ECR, VPC, RDS, S3, Cloudfront, Cloudwatch, CloudTrail, CloudFormation, DynamoDb, Lambda, Route53, Windows Server 2012/ 2008R2/2008/2003, SQL Server 2017/ 2016/ 2014/2012/2008 R 2/ 2008/2005/2000, SSIS, SSRS, SSMS, SSDT, BIDS 2008/2005/2012/2014, Power BI, Microsoft Azure, AWS, MONGO DB SAP HANA, SAP BPC, SAP DW Enterprise Manager, LiteSpeed, CommVault, Idera SQL diagnostic manager, Redgate Backup tool, Tripwire, SCCM 2012, BIT9, Quest Recovery Manager (RMAD), SCOM, StealthIntercept, Migration Manager, T-SQL,PL\SQL, Oracle 11g,SharePoint 2010, Microsoft TFS,SVN Version Control, Toad, VBScript, BMC Remedy Control, Powershell Script, DQS, VMWare

Confidential, ROUND ROCK, TX

AWS ENGINEER/MSBI Developer /SQL Server & MONGO DB DBA/ Database Architect

• Designing and implementation of public and private facing websites on AWS Cloud.
• Migrating from On-Premise Infrastructure to AWS Cloud.
• Configured and managed various AWS Services including EC2, RDS, VPC, S3, Glacier, CloudWatch, CloudFront, and Route 53.
• Infrastructure automation using AWS CloudFormation.
• Configured various performance metrics using AWS Cloudwatch & CloudTrial.
• Written various Lambda services for automating the functionality on the Cloud.
• Used AWS Route 53 for configuring the High-Availability and Disaster recovery to make the environment up and running in case of any unexpected disaster.
• Plan, deploy, monitor, and maintain Amazon AWS cloud infrastructure consisting of multiple EC2 nodes and VMWare Vm's as required in the environment.
• Design RedShift based BI solution platform for optimized performance and usability.
• Deployed and configured Chef Server and Chef Solo including bootstrapping of chef client nodes for provisioning; Created roles, cookbooks, recipes, and data bags for server configuration, deployment, and app stack build outs.
• Maintained the user accounts (IAM), RDS, Route 53, VPC, RDB, Dynamo DB, SES, SQS and SNS services in AWS cloud.
• Designing and developing data warehouse and RedShift BI based solutions.
• Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
• Installed, configured various editions of SQL Server 2014/2012/2008 on multiple servers(Physical & VMware).
• Involved in writing complex SQL queries with multiple table inner and outer joins, temporary tables, table variables, cursors for automating SQL Server migrations.
• Implemented of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers via native sql technique and third party tools such as Redgate backup, idera SQL DM, commvault backup tools.
• Implemented Always ON/Clustering for SQL Server 2012/2014 with various datacenters
• Worked with various teams globally(brazil, Singapore, india) and assigned the minor tasks to offshore teams.
• Configured and monitored numerous MongoDB instances and replica sets
• Implementing on premise MMS monitoring and backup solution. Managing Mongo databases using MMS monitoring tool.
• Installation of MongoDB on physical machines, Virtual machines as well as AWS .
• Automate routine tasks with my own scripts and open-source tools
• Solve production problems and participate in a 24x7 on-call rotation
• Improved mongodb database backups and test recoverability regularly
• Designed the database needs of our applications and optimized them using MongoDB
• Maintained database performance and capacity planning.
• Installed and migrated SAP Business Planning and Consolidation 10.0 from 7.5x with SQL Server 2012 as backend
• Migrated 500 SSAS cubes, 654 SSRS reports, 1000 SSIS from SQL 2008 to SQL 2016, Upgraded 654 SSRS reports from SQL 2008 to SQL 2016 as part of end of life project.
• Worked on SSMA tool with which the raw data has been pulled into SQL tables from Oracle tables.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Worked as part of IEB Research and BI team as a developer extracting big data from Cosmos thru Scope scripting in Visual studio 2012/2014.
• Developed Cross validation rules using to ensure data mapping frequency.
• Implemented row based security in SQL Server 2012\2014 Tabular Models using DAX filters
• Published cube connection files in SharePoint site for Self Service reporting thru creating .ODC and .BISM files
• Written complex SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database as part of data integrity check
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary using SQL Profiler and Index Tuning Wizard.
• Used CTEs for recursive functionality to bring the organization structures and de-duplicate the parent tables
• Involved in complete SSIS lifecycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Handled SSIS packages for Logging, error handling, complex transformations, Deployment and production support.
• Developing OLAP cubes by identifying tables (Tabular & Multi-dimensional), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Developed SSRS reports for the business in Agile project environment.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Published reports and dashboards designed in Power BI utilizing Power BI services and shared it across through Microsoft Office 365.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.

Environment: EC2, Elastic beanstalk, ECS, ECR, VPC, RDS, S3, Cloudfront, Cloudwatch, CloudTrail, CloudFormation, DynamoDb, Lambda, Route53, Windows Server 2012/ 2008R2/2008/2003, SQL Server 2016/ 2014/2012/2008 R 2/ 2008/2005/2000, SSIS, SSRS, SSMS, SSDT, Power BI, Microsoft Azure, AWS, Enterprise Manager, Visual Studio 2008/2005/2012/2014, LiteSpeed, CommVault Backup, Oracle 11g, MongoDB, SharePoint 2010, Microsoft TFS, SAP BPC 10.0, Powershell Script, VMware, BMC Remedy Control.

Confidential, Renton, WA

AWS Solution Architect/MSBI Developer / SQL Server & MONGO DB/ Database Architect.

Responsibilities:

• Experienced in designing and deploying AWS Solutions using EC2, S3, EBS, Elastic Load balancer (ELB), auto scaling groups.
• Responsible for managing infrastructure provisioning (S3, ELB, EC2, RDS, Route 53, IAM, security groups - CIDR's, VCP, NAT) and deployment and EC2 Installs.
• Worked at optimizing volumes and EC2 instances and created multiple VPC instances.
• Experience working with IAM in order to create new accounts, roles and groups.
• Experience in creating alarms and notifications for EC2 instances using Cloud Watch.
• Implemented AWS solutions using EC2, S3, RDS, Elastic load balancer, Auto scaling groups.
• Automate Deployment using configuration Management tool like Puppet to provision Amazon AWS Instances to enable continuous Deployments.
• Involved in maintaining the user accounts (IAM), RDS, Route 53, VPC, RDS, Dynamo DB and SNS services in AWS cloud.
• Configuring and Networking of Virtual Private Cloud (VPC).
• Having extensive experience in AWS Redshift data ware house for columnar data storage.
• Experience involving configuring S3 versioning and lifecycle policies to and backup files and archive files in glacier.
• Created Chef Automation tools and builds, to do an overall process improvement to any manual processes.
• Written Chef Cookbooks for various DB configurations to modularize and optimize end product configuration.
• Experience working on User admin groups, maintaining account and monitoring system performance using Nagios.
• Designed and implemented internal best practices, cookbooks, and automated cookbook with CI and CD system. Made use of Jenkins for Chef CI.
• Worked on Installation and Implementation of Ansible configuration management system and used to manage Web applications, Environments configuration Files, Users, Mount points and Packages.
• Created inventory in Ansible for automating the continuous deployment and wrote playbooks using YAML scripting.
• Used Ansible playbooks to setup continuous delivery pipeline. Deployed micro services including provisioning AWS environments using Ansible playbook s .
• Installed, configured various editions of SQL Server 2014/2012/2008 on multiple servers
• Worked on POC of SQL Server 2014 and designed the database migration plan from SQL Server R2/2012/2014
• Implemented In-memory OLTP for high data insertion rate from multiple concurrent connections using SQL Server 2014
• Migrated Sharepoint, office communicator, SCCM SQL Server database from SQL Server 2008R2 to SQL Server 2012/2014 along with user logins, sql jobs, ssis packages.
• Hosted & migrated databases to Microsoft Azure as IAAS, AWS.
• Used Mongo Chef to explore databases and perform other crud operations on the collections and documents.
• Used other MongoDB third party tools ROBO MONGO, and mongo-built in binaries to monitor and analyze the performance of MONGODB .
• Implemented HA & DR options using SQL Server Always ON, Clustering, database mirroring on SQL Server 2008R2/2012/2014 respectively
• Developed automation powershell &T-SQL scripts for database migrations.
• Enabled table partitioning and on a log table related to Microsoft office communicator when retrieving huge data.
• Upgraded multiple SSIS packages from SQL Server 2008R2 to SQL Server 2012
• Migrated around 100 Crystal reports 3.0 to SSRS reports.
• Wrote hundreds of stored procedures and function on numerous SQL servers to use in SSIS package and Power BI.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards
• Involved in portal design and user interface API interaction to the backend database using .net Frame work Entity model.
• Written Complex T-SQL Queries using SQL Joins, Cursors, Views, CTE’s, Stored Procedures, Functions and Triggers and also scripted Sub Queries using T-SQL involving multiple numbers of tables for application migration.
• Handled SSIS packages for Logging, error handling, complex transformations, Deployment and production support.
• Created Ad Hoc reports by building models in Report Builder using SSRS Model Designer and Report Builder 3.0
• Performance Tuning using indexes, SQL Profiler, Database Engine Tuning Advisor and system views.
• Maintained the Database refreshing till the end of cut over of the project
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc., to make them more attractive and understandable.
• Reporting OLAP cubes built with Microsoft Analysis Services using SharePoint as a front end tool.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc

Environment: AWS, EC2, VPC, Auto scaling, ELB, Red Hat EL 3/4/5/6, CloudWatch, EBS, Directory Services, Route53, Windows Server 2012/ 2008R2/2008/2003, SQL Server 2014/2012/2008 R 2/ 2008/2005/2000, MONGO DB, SSIS, SSRS, SSMS, SSAS, SSDT, BIDS, Power BI, Microsoft Azure, AWS, Enterprise Manager, LiteSpeed, Idera SQL DM, T-SQL,PL\SQL, SharePoint 2010, Crystal Reports 3.0, Powershell Script

Confidential, Houston, TX

SQL DBA\ MSBI Developer

Responsibilities:

• Installed, configured various editions of SQL Server 2014/2012/2008 on multiple servers on Vmware Hosts
• Installed Oracle 11g Client on all newly installed SQL Servers
• Migrated around 5000 databases to newly built 400 SQL Servers as part of company separation.
• Migrated databases from Vegas DC to Bakersfield DC via cloud transfer
• Installed, Configured Always ON/Clustering/ Database mirroring/Clustering as disaster recovery options for newly Built SQL Servers
• Performance Tuning using indexes, SQL Profiler, Database Engine Tuning Advisor and system views.
• Troubleshooting critical performance, space, availability and various issues using TSQL/Powershell
• Developed and enhanced full backup, transaction log backups and purge backup jobs on around 250 servers.
• Installed, configured, Maintained SAP HANA and migrated data from SQL to SAP HANA.
• Maintained SAP HANA databases along with its security roles, developed ETL packages with SAP HANA datasources.
• Designed ETL platform with SAP HANA, SAP DW and multiple sources to SQL & ORACLE databases
• Monitored and maintained multiple instance SAP HANA databases.
• Involved in resolving multiple SAP HANA performance issues.
• Maintained the Database refreshing till the end of cut over of the project
• Creation & Migration of various DB Objects like Tables, Primary Keys, Foreign Keys, Indexes, Stored Procedures, functions across multiple environments
• Implementation of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers
• Migrated logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server 2008 R2 2012 on Development, Testing Production Environments for various mission critical applications.
• Developing OLAP cubes by identifying tables (Tabular & Multidimensional), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Experience in Designing and Data modeling logical/Physical Designs using ERWIN, Database Diagrams etc and Reverse/Forward engineer the data models
• Developed scripts to maintain updated SQL Server information centrally
• Report Models and Drill down reports for Sales, Finance and Revenue Management teams

Environment: Windows Server 2012/ 2008R2/2008/2003, SQL Server 2014/2012/2008 R 2/ 2008/2005/2000, SSIS, SSRS, SSMS, SSDT, BIDS 2008/2005/2012 LiteSpeed, CommVault, T-SQL,SharePoint 2010, VBScript, Powershell script

Confidential, Phoenix, Arizona

SQL Server / Oracle DBA / MSBI Developer

Responsibilities:

• Installed, Configured, maintained SQL Server 2000/2005/2008 R2/2012 databases on various environments.
• Migrated databases, logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server R2 2012 on Development, Testing Production Environments for various mission critical applications as part of end of life project.
• Performed security configuration, user administration tasks like managing users, roles, and profiles, database maintenance tasks.
• Configured MS SQL Server 2005/2008/2012 in-built log shipping/AlwaysON/Clustering/Replication/database mirroring from primary server to standby server as disaster recovery
• Configured and used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Successfully Implement the Multi-Node Active\Passive Clustering for multiple different production applications.
• Participated in application development process and code reviews of database objects
• Generation of SQL Server Storage Reports & Maintaining Daily Check Lists
• Experience in capacity planning. Created custom SSRS reports to track the Database growth and volume changes on periodic basis.
• Experience with RAID levels and SAN storage infrastructure.
• Implementation of MongoDB security mechanism with various Authentications.
• Applied patches and upgraded MongoDB to multiple versions.
• Implemented LVM snapshots backups for large scale MongoDB systems.
• Created multiple databases with sharded collections and choosing shard key based on the requirements.
• Scalable data design for MongoDB with multiple shards .
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup, archival software, media, hardware, and offsite storage.
• Configured Various Replication Types between servers, with separate Distributor server and experience in troubleshooting replication issues in MS SQL Server 2000/2005/2008 R2 Environment to Test the Software.
• Extensively worked on DB Programming using T-SQL in developing stored procedures, Views functions and BAT Scripting.
• Developed various Reports using SQL Server reporting services (SSRS 2005/2008/2012 )
• Involved in Designing and Data modeling logical/Physical Designs using Database Diagrams.
• Assisted application users with migration/up gradation/testing of different Power Builder, .NET and GIS Spatial ( ArcSDE) Applications
• Performed Database backups (operating system, flat file backups & export/import)
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Provided 24*7 supports to SQL application developers in implementing the applications on production server.
• Created development scripts, including rollback scripts, for all SQL Server changes
• Monitoring MYSQL, MONGODB databases on daily basis.
• Maintaining Backups of master and slave servers of MYSQL, MONGO DB with the backup scripts.
• Tuned SQL Server performance using SQL Server Profiler and Execution Plans.
• Install, Configure Oracle 10g, 11g RAC with ASM on Linux(Red Hat), Unix systems
• Configure physical & logical standby databases using Oracle Dataguard for disaster recovery
• Switch over and fail over of Oracle Dataguard databases for Disaster recovery testing using Oracle Dataguard broker DGMGRL
• Configure, Manage, and monitor RMAN backups (Cold Backups, Hot Backups)
• Refresh the test environments with Production data using RMAN duplicate & Data pump
• Performance tuning of the Oracle databases and SQL queries by analyzing the EXPLAIN PLAN ‘s to improve the performance of the database and application end users
• Restore the databases, datafiles, tablespaces from the backups in case of any data loss

Environment: MS SQL Server 2012/2008/ 2005/2000/7.0, IIS 5.0/6.0/7.0, T-SQL, Windows NT/ 2000/2003/2008, Litespeed, SpotLight Enterprise, SQL Compare, PowerShell, SSIS, SSRS, SSAS, BIDS, HPSM, Idera,, DTS, Oracle 10g/11g, MONGO DB, Red Hat Enterprise Linux, Database Tools/Utilities, Enterprise Manager, MySQL, HP service Manager, HP Openview for Operations, Splunk monitoring

Confidential, Milwaukee, WI

SQL DBA\ T-SQL, BI Developer

Responsibilities:

• Installation& Configuration of SQL Server 2008/2005/2000 on Dev, Test and Production environments on Physical and VMware Servers
• Creation and Configuration of SQL Databases including striping VLDB’s (2TB) across multiple files and file groups.
• Performed Microsoft Project Server migration 2010
• Implemented Native SQL Multi Server Administration
• Security Administration (adding logins, users, granting permissions thru roles, managing schemas) on the SQL Server
• Creation & Migration of various DB Objects like Tables, Primary Keys, Foreign Keys, Indexes, Stored Procedures, functions across multiple environments
• Maintained databases by running daily maintenance jobs.
• Implementation of Backup and Recovery methodologies involving Full, Differential and Tranlog backups across Production, UAT and Development servers via native sql & Red gate backup tool
• Migrated logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server 2008 on Development, Testing Production Environments for various mission critical applications.
• Upgrade DTS Packages to SSIS Packages
• Configured Database Mirroring, Log shipping on SQL Server 2005/2008R2
• Created Linked Servers across various data sources including SQL Servers, Oracle.
• Extensively worked on DB Programming using T-SQL in developing stored procedures for generating various Reports using SQL server reporting services (SSRS 2000/2005)
• Monitoring Blockings and Proactively monitor Deadlocks and resolve them by setting up trace flags - T1204,1205,T1222
• Involved in extensive in 24/7 production support and assisted end user in testing application functionality.

Environment: MS SQL Server 2008R2/ 2005/2000/7.0, Windows NT/ 2000/2003/2008, MS IIS 5.0, BizTalk 2000 Server, Project Server 2003/2007/2010, Sharepoint 2007,Visual Studio 2008/2005 T-SQL,XML,LDAP, Active Directories(ADSI), SQL Litespeed, Redgate backup tool, T-SQL, VBScript, JavaScript, DTS/SSIS, Vmware

Confidential, New Paltz

Jr SQL DBA/ SQL Developer/ Report Analyst

Responsibilities:

• Installed, Configured, Monitored MS SQL Server 2000/2005/2008 R2 on different environments using automation techniques
• Implemented Database Mirroring/Log-Shipping as HA on SQL Server 2005/2008R2
• Using the Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Experience in using Oracle BI Discoverer Tool and Pac2000 system
• Secured and audited data using Change Data Capture (CDC) and SQL Server Auditing in SQL Server 2008
• Implemented various functionalities using Triggers, Functions and Stored Procedures in T-SQL
• Building, Managing and performance tuning of SQL database
• Migrating databases from SQL 2000 to SQL 2005\SQL 2008R2
• Linking SQL Server database to Access database in order to create forms, store and modify data
• Using SSIS for ETL data from raw files to SQL Server database
• Using SSRS for generating reports as an improvement over previous methods used.
• Writing complex stored procedures for creating finance reports using Crystal Reports XI.
• Creating reports by installing, maintaining and learning Crystal Reports XI independently
• Everest ERP tool to study and modify E-R diagram

Environment: SQL Server 2000/2005/2008, MS Access 2003, SSMS 2005, Business Intelligence Development SSIS, SSRS and SSAS, Oracle BI Discoverer Tool, Windows 2003 Server, Visual Studio 2005/2008, TSQL, Vmware, Crystal Reports XI, Everest ERP