SUMMARY:

• Confidential Certified Professional with over 16 years IT Experience and around 9 Confidential ERP Dynamics AX System Architect/Administrator including 13 years as Database Solution Architect with demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Confidential 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 Confidential 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 Confidential 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 Confidential 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 Confidential 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 Confidential 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: Confidential Dynamics 365 Finance Operation, Dynamics AX 2012 R3,Dynamics R2/2009/4.0, and Confidential CRM 2015/2013/2011. Siebel CRM 8/7, SharePoint 2016/ 2013/10/2007 .

Database: Confidential 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/9, Redhat 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: Confidential SCOM 2012/Operation Manager 2008/05, Ms Windows Update Service

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

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

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

WORK EXPERIENCE:

Confidential, WI

Dynamics AX Admin Lead/Architect

Responsibilities:

• 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: Confidential 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 Confidential 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 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 Confidential 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 Confidential 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.

Confidential, York, PA

MS Dynamics AX Architect/Database Architect

Responsibilities:

• Involved in Dynamics AX 2012 R2/R3/ERP capacity planning for DENTSPLY.
• Successfully designed and Implementation of MS Dynamics AX 2009/2012 R3/R2 ERP system on Confidential 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.
• Confidential Reporting Services and Analysis services extension configuration and troubleshooting.
• Successfully Designed and implemented Confidential SQL 2014/2012 4 NODEs with AlwaysOn and Multi node cluster/multiple instances on Confidential 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.

Confidential, Philadelphia, PA

Sr. ERP System Architect/Database Architect.

Responsibilities:

• Successfully Designed, Implemented, and Administering Confidential Windows Server 2008 and 2005 Cluster and Confidential SQL Server 2008 and 2005 clusters.
• Design and Implementation of highly available Confidential Dynamics AX 2009 ERP system on Confidential 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.
• Confidential 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 Confidential Windows Server 2008 Cluster and Confidential 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.

Confidential, Philadelphia, PA

SQL Database Administrator 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.

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 Confidential SQL Server 2005 Active/Passive clusters on Confidential 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 Confidential Windows Server 2003 Cluster and Confidential SQL Server 2005 Active/Passive cluster.
• Implementation and administration of Confidential Dynamics AX.40 on Confidential 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.

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 Confidential Windows Server 2003 Cluster and Confidential 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 Confidential SQL Server 2000 to Confidential SQL Server 2005. Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Migrated Confidential 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.

Confidential

Database Administrator and System Administrator

Responsibilities:

• Worked on Database Administration and provided 24x7 supports in production Environment. Managed a team of 5 Network Support Engineers.
• Successfully designed and implemented and administrated Windows 2003/2000 Cluster and Confidential SQL Server 2000 Active /Passive cluster by using HP Storage Area Network.
• Administrated Axapta 3.0 and maintained databases, application files, AOS, client configuration and access permissions. Providing user access according to the requirement, database maintenance plan, monitoring and performance tuning.
• Installed, configured and administrated Oracle 9i on Windows environment. Performance monitoring and tuning. Performed Oracle user authentication, backup and recovery plan, Oracle maintenance tasks, Tuning Queries, Index reorganization/rebuild indexes, blocking and deadlocks issue and User access issues.
• Rebuilt the indexes at regular intervals for better performance
• Designed and implemented comprehensive backup plan and disaster recovery strategies Implemented and Scheduled Replication process.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Designed, tested and implemented of DTS packages. Developed SQL Procedure, Views and Triggers.
• Automated SQL Server error log notification process. Used DBCC.
• Successfully Designed, Implemented, Supported and Administrated Windows 2003/2000 Active Directory Domain, Domain Controllers, Global Catalog Server, Sites, Organizational Units, File and Print Services, Groups Policies Objects, Auditing Policy and Restriction. Created trusts in multiple domain and forests by one way trust or two way trusts.
• Designed and tested Backups and Disaster Recovery strategies and applied in Production environment.

Confidential

Database Administrator and System Administrator.

Responsibilities:

• Worked as System Administrator in Technical support department, provide complete support to Implementation, Migration, Maintenance and end user support.
• Installed, Configured and administrated Confidential SQL Server 2000/7.0. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various groups and users.
• Worked on the SQL Server backup, disaster recovery plan and data restoration
• Worked on T-SQL stored procedures as a part of database maintenance plan for SQL Server 2000. Used system stored procedures and DBCC commands.
• Migrated data and user logon from Confidential SQL Server 7.0 to Confidential SQL SERVER 2000
• Worked on the ODBC Client/Server connectivity.
• Designing, Installation & Administration for Network Operating Systems Windows NT 4.0/2000 configured Windows NT 4.0/Windows 2000 domains and backup file servers for 400 users, LAN/WAN administration task
• Troubleshooting of Network related problems and to provide End User support & Maintenance on Windows NT/2000 Platform
• Evaluated existing LAN environment, and designed the plan to improve Entire network including administration, technical support, reliability of Existing equipment and add-on services. Upgraded hardware and updated OS on Windows NT/2000 File Servers.
• Software and Application Package Administration, Trouble Shooting, Managing System Security, System and Network Performance Tuning.