SUMMARY

• Experience writing, debugging, and tuning Transactional SQL, and stored procedures.
• Ability to ensure the integrity of databases are protected against loss or misuse of information.
• Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
• Database administration including installation, configuration, migrations, consolidations, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL server, Oracle, Teradata.
• Maintenance and tuning of the databases and replication.
• Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
• Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access, Teradata and ORACLE
• Provide SQL Server database physical model creation and implementation (data type, indexing, table design)
• Experienced in configuring HADR using SQL server 2012, 2014, and 2016.
• Experienced in setting up partially contained databases using SQL server 2012, 2014, 2016.
• Experienced in deploying SQL server 2012 cluster solutions.
• Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup, and recovery in managing clusters of SQL servers.
• Provide SQL Server database physical model creation and implementation (data type, indexing, and table design).
• Experience working with merge and transactional replication.
• Management of multi - terabyte production clustered systems using ACTIVE-PASSIVE Clustering.
• Experience with implementing Database Disaster Recovery and Planning
• Experienced with the design, implementation, and administration of SQL Server and Oracle database solutions.
• Have good understanding of virtualization, storage and Server configuration for SQL Server.
• Designed User Defined Routes with custom route tables for specific cases to force tunneling to the Internet via on-premises network and control use of virtual appliances in the customer’s Azure environment.
• Associated routes with VNets via the route table per relationship constraints.
• Experience configuring and troubleshooting Geo Replication.
• Experience working with Database Synchronizations and HUB - MEMBER Topologies
• Experience troubleshooting automated backups and metric management.
• Ability to select correct tier for Azure SQL Databases and Azure SQL Date warehouses.
• Experience working with Performance Metrics and Plan Management
• Ability to working with multi-instance management and authorization.

TECHNICAL SKILLS

Platform: Agilemethodology,Data Loader,AppExchange,Pardot, Tableau, JIRA, Version one Microsoft Visio,Lucid hart, Microsoft Office (Access, Excel, Outlook, PowerPoint, Word, SharePoint), Apex Language, Workflow & Approvals, Dashboards, Reports, Force.com Migration Tool, Custom Objects, data loader, Process builder, lightning concepts, sales cloud, Milestones, Knowledge Management, SQL Query, Agile methodology, Visual Force, Lightning, SDL

PROFESSIONAL EXPERIENCE

Confidential, Lawrenceville, GA

SR. Data Engineer/DBA

Responsibilities:

• Participating in SQL Server database systems design and operations.
• Participating in upgrade and migration efforts for various clients from SQL Server 2008 and 2008R2 to SQL Server 2012, 2014, 2016 and 2017.
• Installation of Oracle Enterprise Manager 11.2.0.3.0 on all databases
• Oracle database administration of test and production databases
• Setup oracle data guard for disaster replication to DR site using Oracle
• IBM AIX 6.1 server maintenance
• Implementation of Oracle Automatic Storage Management
• Implementation of Oracle Real Application Clusters
• Oracle database upgrade from 11.2.0.2.0 to 11.2.0.3.0
• Migration of banking application from T24 to Finacle 10.
• Finacle 10 customizations (JSP & scripting)
• Finacle report customizations using Jasper and MRT IBM storage management - TSM
• Supervise day to day operations of database team members
• Supervise Finacle script development
• Maintain Finacle application environment - deployments and upgrades (patches)
• Created ETL strategy architecture as part of Development plan as part of Development plan to extract and load data from source systems to staging and to destination servers.
• Worked extensively on complete data mapping of all source systems as part of data analysis.
• Extensively used SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages
• Participating in the managing of entire project to which were assigned in accordance with the Service Level Agreement (SLA)
• Statement of Work (SOW) to ensure all departmental related cost and expenses are kept on track with the project schedule.
• Revising current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure.
• Managing an entire database environment visibility and accountable for every database decision made to upper-level management.
• Utilizing expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration to improve uptime as well as reduce RPO and RTO of business.
• Standardizing processes for the Infra DB team by creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
• Working with developers to improve query execution times and boost performance.
• Participate in development of roadmaps and participate in the standards process for Identity and Access Management (IAM) solutions
• Manages the strategy and roadmap implementation for Identity and Access Management Platform Tools
• Manage identity and access management support to business and technical teams in the design of standardized products and customized solutions.
• Performing Installation of different versions of windows as well as post Installation tasks.
• Supporting and stabilizing spiral of production environment; leading to business continuity.
• Participating in the Configuration of various logical database structures such as table spaces to store application objects and rollback segments for transaction processing.
• Participating in the Configuration of the physical design of the database by implementing a flexible Architecture compliance that suites both OLTP and Data warehouse applications.
• Performing periodic database maintenance on all databases across all environments.
• Disk configuration using StarWind Virtual SAN.
• Providing SQL Server database physical model creation and implementation (data type, indexing, and table design).
• Ensuring that all configurations are properly implemented and working based on the client’s needs (Resource Governor, Policy based management etc).
• Proactively monitoring the entire instances and databases for any abnormalities.
• Managing database security settings and configuration
• Engaging in different performance tuning and Query optimization processes.
• Participating in the Configuring of Active Directory and promoting a node to a Domain controller.
• Mentoring younger DBAs in the company.
• Implementing SQL Server best Practices for Installing, Configuring, Troubleshooting, Querying, etc. on all SQL server databases across the enterprise.
• Implementing, monitoring, and troubleshooting SQL Server Replication and Mirroring across all SQL database servers in the enterprise.
• Providing off-hour support for all production databases.
• Managing a multi-terabyte production clustered system using ACTIVE-PASSIVE and ACTIVE-ACTIVE Clustering.
• Participating in periodic database rations for lower environments.
• Writing and tuning T- SQL script, creating stored procedures, views, and triggers.
• Engaging in different project management processes
• Managing datacenter and setting up various measures to manage the said data including partitioning, transactional and peer to peer Replication, log shipping, Mirroring and Clustering.
• Participating in root cause analysis of performance issues within the environment.
• Participating in Project and SQL Team meetings on a weekly basis. successfully engaging in various DR (Disaster Recover) efforts.
• Utilizing experience in various virtualization technologies to manage multiple Sql server on Virtual appliances.
• Performing other duties as assigned.
• Understand and refine a Role Based Security framework. Produce schema designs and operational plans to enforce and maintain identity management workflows.
• Designed the Hadoop platform for high performance and low cost when compared with existing in-house data warehousing systems.
• Architected the congregation of 3 key components of the Big Data platform
• On-Prem third party Massively Parallel Platform (MPP) hardware
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
• Designed VNets and subscriptions to conform to Azure Network Limits.
• Exposed Virtual machines and cloud services in the VNets to the Internet using Azure External Load Balancer.
• Provided high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.
• Implemented high availability with Azure Classic and Azure Resource Manager deployment models.
• Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets.
• Setup Azure Virtual Appliances (VMs) to meet security requirements as software based appliance functions (firewall, WAN optimization and intrusion detections).

Confidential, Atlanta, GA

SR. SQL SERVER Database Developer

Responsibilities:

• Make recommendations toward the development of new code or reuse of existing code.
• Improving performance of T-SQL stored procedures
• SQL Development - Writing Transact SQL, Evaluate large and complex data sets
• Troubleshoot SSIS packages to address critical production issues.
• Develop and Extend SSASCubes, Dimensions and data source views,SSAS-Data Mining Models, Deploying, and processing SSAS objects.
• Used Tableau desktop and SSRS for creating Reports.
• Create Solution Architecture based upon Microsoft Azure PaaS Services
• Design solution for various system components using Microsoft Azure.
• Create Web API methods for three adapters to pull data from various systems like Database, BizTalk, and SAP
• Configure & Setup Azure Hybrid Connection to pull data from SAP Systems.
• Deploying environments/applications fixes, patches, improvements
• Performing environments/applications upgrades
• Analyzing different user requirements and coming up with specifications for the various database applications
• Identifying issues with the database and resolving them
• Installing and configuring the necessary components to ensure that the database is accessible.
• Diagnosing and resolving database access and checking on performance issues
• JIRA execution and defect reporting and tracking using JIRA.
• Providing resolutions to stakeholder's queries effectively on time during UAT.
• Attend scrum meeting to discuss issue prioritization, requirement understanding, issue resolution, defect reporting and requesting help needed etc.
• Expert inanalyzing, designing, developing, installing, configuring,anddeploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008, and SQL Server Integration Services.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience inimporting/exportingdata between different sources like Oracle/DB2/Access/Excel etc. using SSIS.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Ability to handleMultiple tasks,InitiativeandAdaptable.Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies.

Confidential, ATLANTA GA

SR. SQL SERVER DBA/Cloud Admin

Responsibilities:

• Working as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.
• Remote login to Virtual Machines to troubleshoot, monitor and deploy applications.
• Managing Windows 2012 servers, troubleshooting IP issues and working with different support teams.
• Using Power shell to write, debug scripts to automate the processes and do migration of VM, involving copying and creating of VHDS.
• Configuration of Microsoft DevTest Labs to migrate the virtual machines from one subscription to another subscription.
• Managing day to day activity of the cloud environment, supporting development teams with their requirements.
• Creating Labs, Virtual Machines along with setting up policies and using Formulas and Custom Images to deploy the network.
• Managing the ticketing system of ServiceNow to resolve issues on the cloud environment with the cloud management third party team.
• Working on Visual Studio Team Confidential to manage a backlog for the daily activities.
• Provides technical advice and assists in solving database programming problems.
• Create and maintain various databases and database objects on Production QA & development environments using SQL Server 2008R2, 2012, 2014, 2016.
• Monitor the complete environment for resource utilizations to avoid any bottlenecks.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrate SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Extensively worked on SQL Server Integration Services (SSIS), and Tableau Reporting
• Expert in Using DMVs, Performance dashboard, Mirroring.
• CreatedSSISpackages with Error handling, notifications, and package configurations.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2014/2016 that maintained data.
• Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Rebuilding / Monitoring indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• 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
• Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Created alerts for successful or unsuccessful completion of scheduled jobs. Developed ad-hoc queries for end users.
• Migrated production databases from physical servers to VMs.