SUMMARY:

• Experienced database administrator with expertise in SQL Server database administration and development, Dynamic CRM administration/support, web server administration, disaster recovery planning and testing, Enterprise system development and support, Enterprise web application development and support, data migration, application requirements gathering, prototype development and modeling, change management, documentation, vendor sourcing and management.
• More than fifteen years of experience in Information Technology, including four years of hands - on technical management and over three years of project leadership experience.
• Over eight years of Microsoft database administration experience with expertise in installation, configuration, backup and restore, performance tuning of queries, database security and ETL.
• Experienced in Installation, support and maintenance of MS SQL Server 2016, 2012,2005, 2008 R2 in Production, UAT, QA, Testing, Development environments.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• 12+ years of application/database development hands-on experience. Successfully delivered projects on time within the allocated budget.
• Developed sustained relationships with internal management, external vendors and clients based on knowledge and support.
• Over five years of experience in administering and supporting Microsoft Dynamic CRM application.
• Microsoft certified professional.

TECHNICAL SKILLS:

Databases: SQL Server 6.5/7.0/ 2000/2005/2008/2008 R2/2012/2016, MS Access 97/2003.

Languages/tools: ASP 2.0/3.0, VB.Net, Visual Basic 5.0/6.0, COM, MTS/COM+, Java Script, VB Script, T-SQL, MS Visio.

ETL tools: MS SSIS 2008, MS SQL Server 2000 DTS, Scribe Insight.

Operating Systems: Windows 2016, Windows 2012, Windows 2008, Windows 2003.

Server applications: Microsoft Exchange 2013/2010/2007 , Blackberry Enterprise Server, Microsoft Navision, Citrix Presentation Server, Microsoft Dynamic CRM 2013/2011.

Reporting tools: Microsoft SQL Server Reporting Tool.

Analytical tools: Microsoft Power BI.

Configuration management tools: Microsoft Team Foundation Server, Microsoft Visual Source Safe.

Web monitoring/trend analysis tools: Net IQ, Web Trends.

Data backup tool: Symantec backup Exec.

PROFESSIONAL EXPERIENCE:

SQL Server Database/CRM Administrator

Confidential, Bloomfield Hills, MI

Responsibilities:

• Installing and managing SQL servers in Production, UAT, Integration, Staging and Development environment. Monitoring performance issue and implementing the corrections for slow running queries/procedures.
• Creating SSIS packages for data migration and loading.
• Integrating third party data feeds.
• MS Dynamics CRM server administration and first level CRM application support..
• Developing database objects for the development team.
• Database schema review and approval.
• Reviewing the SQL statements to ensure accuracy and optimum performance.
• Creating, reviewing, consolidating and maintaining index/statistics for optimal performance of the database and application.
• Database administration of production, staging and development servers.
• Setting up the jobs and alerts on SQL servers to proactively monitor the performance and take corrective actions.
• Involved in the capacity planning and upgrade of hardware for database and CRM. Collaborating with IT Infrastructure team in procuring and installation of new hardware for database environment.
• Set up the Disaster Recovery site for database servers and CRM environment.
• Testing DR environment and daily database backups.
• Supporting Marketing email integration with business application.
• Creating and maintaining ETL scripts/jobs for analytics.
• Successfully migrated MS TFS 2013 to MS TFS 2015. Involved in successful migration of Microsoft Visual Studio 2013 to Microsoft Visual Studio 2017.

Environment: MS Windows Server 2016/2012/2008 , MS Windows 2010/2008, IIS Web Server, SQL Server 2016/2012/2008 /2008 R2, Idera Diagnostics Manager, .Net, Scribe, MS CRM 2011/2013, Microsoft Power BI, Microsoft Team Foundation Server

SQL Server Database Consultant

Confidential, Modis

Responsibilities:

• Database administration of the production and staging servers - MS SQL Server 2000, MS SQL 2005 and MS SQL Server 2008R2.
• Installing and managing SQL servers in Staging and Development environment.
• Troubleshooting and fixing SQL Server performance issues.
• Setting up and monitoring data transfer jobs on the SQL server.
• Creating Windows jobs to FTP SQL database files from external and hosted servers.
• Setting up alerts for proactively monitoring Database servers for free disk space on the drives, status of the services, non dbo objects on the servers, failed jobs etc.
• Maintaining database access control and auditing the users.
• Setting up and monitoring database backup jobs (SQL Lite speed and SSIS).
• Migrating databases from SQL 2000 and SQL 2005 environment to SQL 2008 R2 64 bit platform.
• Documenting the process and procedures.
• Working with the development teams to implement database schemas for the product line.

Environment: MS Windows Server 2003/2008, MS Windows XP/7.0, IIS 6.0/7.0, SQL Server 2000/2005/2008/2008 R2, ASP 3.0, ASP.net, VB.Net, WS FTP, Quest SQL Lite Speed 6.1.

Tech Lead and Database Administrator

Confidential

Responsibilities:

• Database administration of the production servers - MS SQL Server 2000 and MS SQL Server 2008.
• Development and support of ETL. Loading data from AS 400 into databases on MS SQL Servers. Loading data from MS SQL Servers into SalesLogix (CRM) database.
• Database development support. Providing database development support to application development team. Designing and creating database schema, developing database objects - stored procedures, user defined functions etc.
• Documenting the application database schema.
• MS Visual Source Safe 2005 administration and support.
• MS Dynamic CRM database support and data loading support.
• SalesLogix database support.
• SQL Server installation and security administration.
• Database backup support and job monitoring.

Environment: MS Windows Server 2003/2008, MS Windows XP, IIS 6.0, SQL Server 2000/2008, ASP 3.0, ASP.net, VB.Net, VB 6.0, MS Visio, Scribe Insight, SalesLogix, MS Dynamic CRM online.

Senior Web Developer and Database Programmer/IT Manager

Confidential, Southfield, MI

Responsibilities:

• Managing the Information Technology Department at Solium’s U.S. operations headquarters.
• Server administration, patch management, server maintenance, license management.
• Database administration, database programming, backup and restore support, backup tape management, database security, database queries tuning.
• Web application development, coding, documentation, unit/system testing, deployment, content management and enhancements, application security implementation for SQL injection and cross-site scripting.
• Avaya telephone system support.
• Network administration, support and vendor management.
• Disaster recovery planning and testing.
• SAS 70 audit support and compliance, including database security audits and user audits.
• IT Help Desk management/support.
• Web server administration and security certificate management.
• Citrix Presentation Server administration, application publishing and security management.
• Supporting a suite of business applications.
• Managed two web/database developers.

Environment: MS Windows Server 2003, MS Windows XP/Vista, IIS 6.0, MS Exchange Server 2003/2007, SQL Server 2000/2005, ASP 3.0, ASP.net, VB.Net, VB 6.0, MS Visio, Crystal Report, SalesForce, Citrix Presentation Server 4.5, Blackberry Enterprise Server 4.1.4.17.

Project Leader/Analyst Programmer

Confidential

Responsibilities:

• Developed, deployed and supported Inmate Transfer System and Office of Professional Responsibilities Tracking System.
• Involved in all phases of Software Development Life Cycle - project initiation, requirements gathering, functional design specification, prototype development, application design, web application coding, unit testing, system testing, data migration from mainframe system to Microsoft SQL Server 2000, application security matrix creation and implementation, end user training, application support.
• Managed the application development team of 14 developers and analysts to set project milestones and deliverables.
• Managed database development team, designed the logical database structure, and created the physical database objects and performed queries tuning and optimization.
• CMM/PCMM audit support.

Environment: MS Windows 2003 Server, MS Windows XP, IIS 6.0, SQL Server 2000, ASP 3.0, ASP.Net, VB 6.0, VB.Net, Java Script, MS Visio, COM+, MS Visual Source Safe 6.0.

Analyst Programmer

Confidential, Cupertino, CA

Responsibilities:

• Redesigned existing IPMScout web application for performance improvement.
• Web application development, coding, testing and deployment.
• Database programming, stored procedure/UDF creation.
• Database porting from Access 97 to SQL Server 2000.

Environment: MS Windows NT Server, MS Windows XP, IIS 4.0, SQL Server 2000, MS Access 97, ASP 3.0, Visual Basic 6.0, COM+, Java Script, MS Visual Source Safe 6.0