SUMMARY:

• Enthusiastic technology team player with sound business acumen of retail and point of sale processes.
• Plan, develop, and implement IT solutions using SQL Server to deliver best experience for end - users.
• Possess breadth of experience in data management, design and database administration in various industries.
• Highly skilled communicator with ability to explain technical situations in clear and concise manner so that professionals of all levels and backgrounds can understand.
• Lead by example with strong work ethic, integrity and focus on quality solutions to meet customers’ and organization’s goals.

TECHNICAL SKILLS:

SQL Server: MS SQL Server 2012 / 2008R2 / 2005 / 2000

SQL Server Features: Always On, Windows Clusters, Failover Cluster Instance, High Availability.

Development: T-SQL, PowerShell, Visual Studio 2008, VB.net, VB 6.0, ASP.Net, XML, HTML.

Tools: SSMS, Query Analyzer, BI Development studio, Extended Events, SQL Profiler, SSIS, SSRS, Import and Export Wizard, Enterprise Manager

Monitoring Tools: SentryOne SQL Server Monitoring tools, PRTG Network Monitor

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports 9.0

SQL Server OS: Windows 2012R2, Windows 2008R2, Windows 2003

POS / Other applications: Oracle (Micros) xStore 5 and xStore 7, Relate, Order Broker (Locate) Epicor Coalition POS, Web EJ, Afaria Administrator AJB (Verifone) Polling and Credit Switch / Tokenization configuration / maintenance StoreForce

PROFESSIONAL EXPERIENCE:

Confidential, North Bergen, NJ

SQL Server Database Administrator

Responsibilities:

• Decreased deployment and upgrade times 25% by developing and implementing SQL Server 2012 upgrade process on critical 20+ instances, training teams and standardizing deployment procedures.
• Worked extensively on production environment and automation of multiple tasks across 100+ servers, upgrading multiple instances simultaneously within short period of time.
• Automated and tested backup and restore procedures on over 30 SQL Server instances improving efficiency and saving time.
• Saved $1M by downgrading SQL Server 2008R2 edition reducing license costs on 500+ devices in 2 months.
• Aided vendor in upgrading the point-of-sale and host server application and databases in timely manner.
• Provided staff with easy access to complete details of SQL Server instances and all of application servers due to documenting all SQL Server instances and host servers for future reference and troubleshooting.
• Programmed using scripting languages, such as VBScript and PowerShell, to automate monitoring and upgrade processes, allowing department to review logs and reports in 1 folder for all servers.
• Performed SQL Server migrations, consolidations, and upgrades, including validation, clean-up, and mapping to free up resources due to initiative to eliminate older storage drives and improve database speed.

Confidential, North Bergen, NJ

SQL DBA

Responsibilities:

• Architected Failover Cluster Instance including 2 nodes Always On and High Availability setup improving instances running on its’ own server with minimal downtime.
• Coordinated team of 3 database and application administrators to manage day-to-day operations of single global instance monitoring CRM and SALE Transactions database instances.
• Configured and managed over 800 linked Servers (including point-of-sale devices) creating environment for ETL procedure to run and process missing transactions rapidly when all missing data was pulled by stored procedure.

Confidential, North Bergen, NJ

SQL Server Database Admin

Responsibilities:

• Troubleshoot critical issues, utilizing SQL Profiler, and SQL Server Management Studio extensively to resolve issues and improve efficiencies.
• Upgraded SQL Server version from SQL Server 2005 to SQL Server 2008r2 and application server supporting company growth and eliminating need for outsourced consulting charges.
• Managed users and user access levels for each segment of database protecting databases’ security.
• Developed automated backup jobs and DBCC scripts for databases and transaction logs developing standard process for all teams which empowered individuals to create and run those jobs independently.
• Implemented and maintained routine DBA tasks, such as scheduling jobs and creating maintenance plans.

Confidential, North Bergen, NJ

Retail SQL Server Database Admin / Net Developer

Responsibilities:

• Developed large tools and systems to monitor and report status of all POS and Host systems allowing team to review and resolve issues for 3K+ devices automatically.
• Upgraded point of sale from legacy system to latest available system, using new Microsoft technologies, reducing overall costs and improving efficiency.
• Designed and implemented more effective POS staging procedures which e.g., decreased time-to-stage from 2 days to 1-hour register.
• Permitted all teams to perform files transfers and upgrades at any time through developing Afaria Administrator channels to monitor and manage SQL Servers on all POS registers.
• Devised and developed different reports to monitor and analyze sales and traffic in retail stores, providing hourly updates to Store Team.
• Configured and managed StoreForce application interfaces and SQL Server databases which consolidated sales and traffic data to backend servers without using any outside vendor.

Confidential, Lyndhurst, NJ

Programmer Analyst and Database Developer

Responsibilities:

• Designed, developed and implemented Carton Receiving, Store Ledger, Style Locator, Carton Transfer.
• These applications were used by retail stores to view, print and create files from PDT3100 Scanner.
• Time Clock was used to get hours information from all stores on Sunday night for payroll.
• Administered SQL database to store, maintained company’s sales data, customer information and shopper information as well as generated various management reports.