SUMMARY:

• Microsoft Certified Professional with over 15+ years IT Experience and Microsoft ERP Dynamics AX System Architect/Administrator including Database Solution Architect with demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Microsoft ERP Dynamics 365, Dynamics AX 2012 R3/R2/2009 and MS SQL Server 2016/14/2012/08/05/2000 Active/Passive Cluster/dispersed, Always On and Oracle 11g/10g/9i and Worked as a part of 24x7 Total Technical Supports
• Responsible to Plan, direct and oversee full life cycle Implementation of Microsoft ERP Dynamics AX 2012 R3/R2/2009 and Database Infrastructure design and management Operation, leading projects, cost saving and meeting goals. Implementing IT procedure policies and best practices.
• Implementation and administration of Microsoft ERP Dynamics AX (Axapta) 2012 R3/R2//2009/4.0 on SQL Server, AOS Cluster/Load balancing, Enterprise portal (EP) load balancing reporting extensions and analysis Service extension, Setting up AIF, DIXF and DMF.
• Expertise in Microsoft Dynamics 365 for Finance and Operations Implementations, configurations and administrations.
• Expertise in Ms Dynamics AX 2012 R3/R2 Retail Module designing and full cycle implementation of Brick and Mortar Retail Store and E - Commerce Online Store on SharePoint Farm and Sitecore Environment. Deep experience on CDX, Realtime Service, Async Server/Client, Retail Servers and Modern POS. Channel DB and Offline DB for Retail.
• Various Modules include FI, SCM, Production and Manufacturing Business processes and configurations.
• Expertise and Interest include Database infrastructure Design, Administration, Performance Analysis and troubleshooting of Production Complex Databases,
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Data Design and Development on SQL Server system in OLTP/OLAP environment.
• Design Relational Databases model and Implementation as per business needs.
• Successfully Designed and Implemented Windows Server Cluster with Microsoft SQL Server Active/Passive clusters with AlwaysOn by using HP/Compaq, IBM SAN, NetApp SAN and EMC.
• Successfully Designed, Implemented and administrated Oracle 11g/10g/9i, RAC, Data Guard on UNIX/LINUX and Windows. Used SQLPLUS, PL/SQL, RMAN utility and SQL Tuning Advisor.
• Experience in extracting and transforming data using SSIS and DTS Import/Export Data, Bulk Insert, BCP and DTS, Oracle Exp/Imp, 10g Data Pump and Oracle SQL Loader Utilities.
• Experience in Database administration activities for SQL Server and Oracle Security (creating users, roles, and assigning permission to them).
• Experience in Performance Tuning, Query Optimization and Client/Server Connectivity.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Installed and configured IIS 7.0/6.0/5.0 for Intranet and Internet websites in Windows 2012/08/3/00 Servers. Successfully Implemented, supported and Administrated Microsoft SCOM monitoring system. Performance, Monitoring Critical Alerts and Notifications.
• Active Directory Domain, Domain Controller and one way trust or two way trusts.
• Designed and Implemented Backup and Restore utilities and Disaster Recovery in various platforms. Organized Exceptional and Professional Documentations, Trainings, Presentations and Oral/Written Interpersonal Communication Skills.

TECHNICAL SKILLS:

ERP Applications: Microsoft Dynamics 365 Finance Operation, Dynamics AX 2012 R3Dynamics R2/2009/4.0, and Microsoft CRM 2015/2013/2011. Siebel CRM 8/7, SharePoint 2016/ 2013/10/2007 .

Database: Microsoft SQL Server 2016/14/2012/08/05/2000 , Oracle 11g/10g/9i and Sybase ASE 15/12.5

Server OS: Ms Windows Server 2012/2008/2003/2000 , SUN Solaris 10/9Redhat Enterprise Linux 5/4 and IBM AIX 6/5 linux/Unix.

Desktop OS: MS Windows 10/08/07Vista/XP/2000/NT 4.0/ and Ms-Dos 6.22.

Management: Microsoft SCOM 2012/Operation Manager 2008/05, Ms Windows Update Service

Backup Software: MS Backup, VERITAS, CommVault and ARCserve.

Virtualization: Microsoft Hyper-V 2012/08, VMware ESX Server 5/4

Hardware: Compaq/HP Proliant and Blades Servers, IBM X series Servers Servers and Dell Power Edge Servers. HP Storage and EMC Storage.

WORK EXPERIENCE:

Confidential, Arcadia, WI

Dynamics AX Admin Lead/Architect

Responsibilities:

• Working as a SME and responsible for Microsoft Dynamics AX 2012 R3 Retail module Design high availability and Implement full life cycle of E-Commerce on Sitecore online store, SharePoint Farm and Brick and Mortar Retail Systems with SQL Server 2014 Enterprise with AlwaysOn deployment.
• Installing and configuring all aspects of Dynamics 365 for Finance and Operations.
• Configuring and maintaining Dynamics 365 for Finance and Operations administrative tasks such as (User Management, Configuration, and Deployment).
• Dynamics Lifecycle Services (LCS) to monitor and tune environments, deploy features, and stay up to date with recent hotfixes.
• Turning ON/OFF maintenance mode: Microsoft Dynamics 365 for Finance and Operations includes a new system-wide setting that is named maintenance mode.
• Environment refresh for Dynamics 365 finance and operations from azure SQL to SQL Server environment using bacpac process.
• Successfully Designed, Implemented and administrating Microsoft Dynamics AX 2012 R3 Retail Environment from Develop, Test, UAT, Stage and Production Environment with full high availability with load balancing configuration including SQL Always Feature and failover capability.
• Configuring AOS Load balancing and AX cluster configurations,
• Dynamics AX Development and customization. X++ programing, MorphX Development solutions, AIF, DIXF, Enterprise Portal
• Dynamics AX performance review, analyze and performance optimizations and troubleshooting.
• Deep understanding and configuring Retail Headquarter, Commerce Data Exchange which includes Real time service, Async Server/Client, Channel DB/Offline DBs, Retail Servers and Modern POS.
• Configurations of Retail Components includes Retail Scheduler Jobs, Retail Channels, Channel data group, Channel DBs and Catalogs, Products
• AX Codes XPOs, Models, ModelStore and Data deployment Strategies and methods, utilizing Microsoft Dynamics AX management Utilizes and Powershell. Data refresh from production to lower environment.
• Dynamics AX Technical issue, performance tuning and troubleshooting, AX Database servers maintenance and optimizing slow running AX jobs and DIXF jobs. Dynamics AX Security roles, duties and privileges development and customizations as per security and business needs.
• Installation and administration of Windows 2012 R2 Cluster with SQL Server AlwaysOn features. AX SSAS, SSRS load balancing, Integration services and Analysis Service. Dynamics Management Reporters.
• SharePoint 2013 Farm Implementation and administration and Enterprise Portal and Role center with ADFS authentication and online Stores.
• Experienced in troubleshooting and isolating the issue quickly and taking actions resolutions and co coordinating with Microsoft consultants and developers, Functional Teams and Business Analysts, QAs and Business users.
• AX Webserivee configurations and trouble shooting and load balancing.
• Applications Integration EDI, AvaTax, DataMason. AIF and WCF and BizTalk configuration for AX.
• Develop methods, process and documentations and coordinate with 3rd party vendors to implement application integrations.

Environment: Ms Dynamics 365, AX 2012 R2 CU8, Ms SQL Server 2014/2012, Windows Server 2012 R2, NetScaler, F5, SharePoint 2013 Ent, Microsoft RDS service and Citrix, Avatax, DataMason EDI and Sitecore.

Confidential, York, PA

Dynamics AX Architect/Database Architect

Responsibilities:

• I am responsible to Design and Implement full life cycle of Microsoft ERP Dynamics AX 2012 R3/R2 Infrastructure/Microsoft SQL Server 2012/2008, Implementation and administration by using Best Microsoft practices and Involved in the Data center Migration.
• Involved in Dynamics AX 2012 R2/R3/ERP capacity planning for Confidential .
• Successfully designed and Implementation of Microsoft Dynamics AX 2009/2012 R3/R2 ERP system on Microsoft SQL 2012/2008 Cluster environment with AlwaysOn.
• Dynamics AX AOS/Enterprise portal load balancing, administration and performance and optimization. Expertise in Dynamics AX administration and Performance troubleshooting.
• Designed and Implemented Always On for Dynamics Databases and other Application Databases.
• Microsoft Reporting Services and Analysis services extension configuration and troubleshooting.
• Successfully Designed and implemented Microsoft SQL 2014/2012 4 NODEs with AlwaysOn and Multi node cluster/multiple instances on Microsoft Windows 2012/2008 R2 enterprise.
• Design and implemented Enterprise SharePoint environment for Dynamics AX enterprise portal, SSRS reporting services extension and SSAS analysis services integration extension.
• Working with Developers, technical, Functional teams and articulate process, Data processing procedure and implementation methods documentation. Coordination and develop communications among various team. Various modules business processes, configuration and management.
• Dynamics AX Security Development and customization. Deploying and configured AIF/DMF.
• Develop, test and deployment Legacy Data migration to Dynamics AX using Data migration framework and Data loading. Setting up Workflows.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Responsible for ensuring the reliable performance of ERP systems, Monitor server performance, AX SQL Tracing and finding bottleneck, setting up Performance counter for Dynamics AX and SQL Servers.
• AX development codes move on different environment by Utilizing AX model Store, AX Model Files and XPO moves to migrate code. Refreshing Dev, Test and Staging environment from Production.
• Implemented database maintenance plan for BizTalk Servers
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support. Manage AX user and security groups
• Performed all aspect of database administration, table partitioning, backup strategies, recovery, and replication for SQL server 2014/12/08/05.
• Analyze some of the long running slow queries & tune the same to optimize application and system performance by using DMVs/DMFs. Used system stored procedures and DBCC commands.
• Rebuilding the Indexes at regular intervals for better performance. Tuned SQL queries and stored procedures using SQL Profiler and database tuning advisor.

Environment: MS SQL Server 2005, T-SQL, Win 2003/Windows Server 2008 R2, VB, ASP, Dynamics AX 2012 R3, R2, 2009 and Siebel Analytics.

Confidential, Philadelphia, PA

Sr. ERP System Architect/Database Architect.

Responsibilities:

• I was responsible for Database Infrastructure designing, best practice recommendation, Implementation of Microsoft SQL 2008 clusters, administration and troubleshooting for various projects and applications.
• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2008 and 2005 Cluster and Microsoft SQL Server 2008 and 2005 clusters.
• Design and Implementation of highly available Microsoft Dynamics AX 2009 ERP system on Microsoft SQL 2008 Cluster environment.
• AX AOS/Enterprise portal load balancing, administration and performance and optimization. Ms Reporting Services and Analysis services extension.
• AX Systems refreshing on various environment from Production AX Environment and AX development codes migrations.
• Working with Developers, Function teams and other infrastructure team. Coordinating and supporting to implement process, standards and Application security standard.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies. Building SQL Servers and cluster standards and security Standards.
• Monitor database log files, data block corruption, segment fragmentation.
• SQL Server and AX Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Worked on migration from Ms SQL Server 2000/2005 to Ms SQL Server 2008 clusters.
• Microsoft Hyper-V and VMware ESX virtualization used for consolidation of database servers and application servers.
• Environment: MS SQL Server 2008/05/00, Oracle 11g/10g, Win 2008/03 RedHat 5, IIS, FTP, DTS, SSIS, MQ Series, WBI VB, ASP, XSL, XML Web Services, JavaScript, CSS, IIS 7/6 and SSRS and SSAS.

Confidential, Harrisburg, PA

Sr. Database Administrator

Responsibilities:

• Worked as a Database Administrator and I was responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases and Oracle Database.
• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2008 Cluster and Microsoft SQL Server 2008/2005 Active/Passive clusters.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implementation of Oracle 10g on AIX Servers, performed administration and performance monitoring.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment. RMAN utility, 10g Data Pump and Exp/Imp, SQL Tuning advisor. Database security and standards.
• Implemented and administrated Oracle data guard for disaster recovery.
• Designed and developed SQL Server SSIS for data migration and ETL for loading data to data warehouse.
• Implementation and administration of Microsoft SSAS 2008/2005and SSRS 2008/2005
• Worked on SQL Server Data Partitioning, Snapshot replication and transactional replication.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• SQL Server and Oracle Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with other department’s team.
• Responded to trouble tickets assigned and fixed any database issues promptly, worked on projects that initiated by higher management.
• Worked on VMware virtualization in development and testing environment.

Environment: MS SQL Server 2008/05/00, Oracle 10g, Win 2008/03 AIX Unix, IIS, FTP, MQ Series, SAP, WBI VB, ASP, XSL, XML Web Services, JavaScript, CSS, IIS 7/6, SSRS, SSAS SSIS.

Confidential, Philadelphia, PA

SQL Database Adm inistrator Lead

Responsibilities:

• Successfully Designed, Implemented and administration of MS Windows Server 2003 and MS SQL Server 2005 for production and staging.
• Designed and supported to build Data Warehouse Star Schema by using Erwin Data Modeler.
• Designed and developed SQL Server Integration Services (SSIS) to pull full monthly and daily incremental data from Oracle Database.
• Designed and developed ETL for loading data from staging to Data Warehouse. Scheduled SSIS packages.
• Implemented SQL Server Security, Backup and Restore policy. Scheduled jobs and alerts using SQL Server Agent.
• Developed T-SQL stored procedures as a part of database maintenance plan for new SQL Server 2005.
• Performed all aspect of database administration, tuned SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor (DTA).
• Supported for designing and implementation of Cognos Reporting.

Environment: MS SQL Server 2005, T-SQL, Win 2003, IIS, FTP, DTS, SSIS, Oracle 9i, Web Services, IIS 6.0 and Cognos 8 Reporting.

Confidential, Harrisburg, PA

Database Administrator (Consultant)

Responsibilities:

• Worked MS SQL Server 2005/2000 Administrator and I was responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases.
• Successfully Designed, Implemented, and Administering Microsoft SQL Server 2005 Active/Passive clusters on Microsoft Windows Server 2003 Cluster.
• Worked on Oracle 10g on AIX Servers and performed Installation, administration and performance monitoring.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment. RMAN utility, SQL Tuning advisor. Database security and standards.
• Oracle database security and Users authentication. Tablespaces, data files, SQL/PLUS and PL/SQL.
• SQL Server and Oracle Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Designed and developed SQL Server Integration Services (SSIS) for data migration and Extracting and transforming data. Worked on SSAS and SSRS.
• Rebuilding the Indexes in Oracle and SQL Server at regular intervals for better performance.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with other department’s team.

Confidential, Richmond, VA

MS SQL Server DBA/Dynamics AX DBA

Responsibilities:

• Successfully Designed, Implemented, and Administered Microsoft Windows Server 2003 Cluster and Microsoft SQL Server 2005 Active/Passive cluster.
• Implementation and administration of Microsoft Dynamics AX.40 on Microsoft SQL 2005 Cluster.
• Dynamics AX4.0, AOS with NLB, enterprise portal, business connector configuration, User management and security standards and performance tuning.
• Creating and Maintaining Databases, Adding Users, Roles, and Groups and assigning privileges according to the project needs.
• Created Database Maintenance plans, Managed Database Structures, Disk Spaces, DTS packages, scheduling Database Backups, Restoring Databases and Maintained data accuracy and consistency.
• Migrated DTS objects to SQL Server Integrated Services(SSIS) environment
• Setup transactional and snapshot replication, Implemented log shipping technology. Worked on Data partitioning and performance tuning.
• Analyzed, fine-tuned and optimized MS SQL Server Applications by using Performance Monitor, setting up traces using SQL Profiler.
• Provided support to the Data Center team in their development and truncated the transaction logs to check the space of the exponentially expanding databases.
• Performed upgrade of OS, Applications & file system expansions as and when required. Used VB scripts.
• Managed the production database servers Taking daily backups by using VERITAS Net backup.
• Daily basis reviewed performance monitoring and Windows and SQL Event Logs and System Logs.
• Performed troubleshooting and maintained H/W and networking problems
• Tested Windows and SQL Server critical and security Patches on test LAB and installed in Production environment.

Environment: MS SQL Server 2005/2000, Windows 2003/2000 Servers, IIS, FTP, Oracle 9i, SQL Profiler, VERITAS, MS MOM 2005 Server, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services and Network Support.

Confidential, Stamford, CT

Database Administrator

Responsibilities:

• Responsible for SQL Databases on 4 Cluster Active/passive servers, Implementation and administration of Active Directory logins and SQL Logins, Roles and Authentication Modes according to the requirement for various categories of users and groups.
• Successfully Designed, Installed, configured and Administered Microsoft Windows Server 2003 Cluster and Microsoft SQL Server 2005 Active/Passive cluster.
• Installed, configured and administered and troubleshooting Oracle 10g high availability on SUN Solaris.
• Monitor database log files, data block corruption, segment fragmentation.
• Backing and recovery of Oracle databases. SQL/PLUS, PL/SQL, RMAN utility, SQL Tuning advisor, Performance and tuning, DBCC.
• Oracle and SQL server databases performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Working data partitioning for new SQL server 2005 databases and created partition function, partition scheme mapped to a partition function and created the table on the partition scheme.
• Migrated Microsoft SQL Server 2000 to Microsoft SQL Server 2005. Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Migrated Microsoft Analysis Services to SQL Server Analysis Services (SSAS)
• Designed and Implemented Sybase ASE server and performed administration. Backing up and restoring database. Creating SQL logins and giving appropriate permission. Monitoring database spaces.
• Managing Sybase and performance monitoring and disaster recovery.
• Designed and implemented Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and high availability.
• Maintained Reporting services on MS SQL 2005/2000 platform.
• Implemented and administrated transactional and snapshot replication.
• Day to Day basis reviewing Performance monitor and Event logs on all Oracle Server and SQL Servers.
• Verify backups and error logs on the SQL servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Environment: Oracle 9i/10g, MS SQL Server 2005/2000, Sybase ASE 12.5, Sun Solaris, Windows 2000/2003, IIS, FTP, Siebel, ASP.Net, C#.Net, ADO.Net, XML, XSL, XML Web services, JavaScript, CSS, IIS 6.0 and Crystal Reports.