Experience

enta Ticketing Solutions ("enta")

• United Kingdom
• Software Development
• 1 - 100 Employee

• SQL SERVER Administrator (S)

  • Jul 2009 - Present

  • Administration and optimization of SQL Server 2005/2008/2014/2016 Databases • Azure database management • SQL Change Tracking • Installation and support of database Encryption (PCI - DSS) • Data warehousing and Data Segration. • T-SQL for SPs, for maintenance and enhancement • SQL Server Maintenance in Cluster Enviroment • Configure/Monitor log shipping • SSIS packages using expression, conditional flow and error handling • Creating/monitoring Merge Replication and Mirroring configuration • AlwaysOne high availability design for production databases • Working along Tech team to provide support to customers. • Scheduling and running DTS Packages • Upgrading Database and migration of SQL servers • Importing and Extracting data into .txt and .CSV files • Running and Managing Schedule jobs • Working with Backup Devices / Linked Server • MySQL Integration • Injecting data direct to API server from SQL Box with assembly dll's Show less



Legal Documents Services Internal - LDSI

• Manchester, United Kingdom

• SQL SERVER Administrator (DBA)

  • Jan 2008 - Jun 2009

  • Administration and optimization of SQL Server Databases • Implementation of relational database concepts and database design • Maintaining/writing Store procedures • Working with Function both Table value and Scalar function for the application that is running on web base • Writing triggers(Server Level, database levels) • Maintaining the Table/Views performing by implement right level indexing • Creating/monitoring Replication • Mirroring and designing of Failover system for live databases • Creating/Modifying DTS and SSIS Packages • Scheduling and running DTS Packages • Importing and Extracting data into .txt and .CSV files • Supporting web/developer teams • Working as 2nd line support(web base application design in ASP.Net/Java/.Net 2008) in case of emergency • Upgrade databases using RED GATE software • Working with Backup Devices / Linked Server • Designing Reports using SQL Services Show less



Joysleep Limited

• Furniture and Home Furnishings Manufacturing
• 1 - 100 Employee

• IT Administrator

  • May 2007 - Dec 2007

  • Software and database Management • Design and Maintain SQL Server 2000/2005 Database, • Implement Indexes and optimize the Queries • Import and Export of Data within Database • Provide management with an adequate decision support system by providing information that is timely, accurate, consistent, complete, and relevant • Maintenance Sage and Opera Database • Creating and modifying Reports designed in Crystal Report 8 • Connect to different data Sources through Crystal Report using ADO data source • Work in security services and standards: Firewalls, IPSec VPNs, RADIUS • Detailed knowledge of Anti-Virus/Spam/Spyware products and technologies (esp. Sophos, Aniti Spywares) • Working networking & TCP/IP protocols knowledge: routers (Cisco), switches (Cisco, HP), DNS management (zone files etc.), DHCP, FTP, RIP, BGP, etc. • Daily Backup Software’s ( Veritas Backup Exec). Show less



Advanced Pharma International Inc.

• United States
• Pharmaceutical Manufacturing
• 1 - 100 Employee

• Software Developer

  • Apr 2004 - Feb 2007

  • System Analysis & Design according to company requirements • Development & Implementation of major Information Systems. • Designing the Infrastructure for implementation at client end. • Designing and structuring entire Databases. • Development and Deployment of Developed Software Applications. • Responsible for preparing Software Requirement Specification, Functional Specification and Implementation Plans. • conducting User Acceptance Tests and Providing Training to the application users. • Responsible for Handling and Modification of deployed applications. • Responsible for Designing the Infrastructure for implementation at client end. • As team leader of highly skilled software engineers, troubleshooting and debug Softricity’s Soft Grid Platform, a multi-threaded, multi-user system comprised of windows services, a core infrastructure, a virtual application environment, kernel mode drivers, and a managements system. • Predict & implement other tools and utilities that solve specific problems in support of our customers. • Reviews, analyze, design, program, modify, develop and implement software programming application. • Lead to write code and complete programming, and testing of systems and applications. • Lead to convert project specification and procedure to detailed logical flow charts for coding into computer language. • Supervise production data, data management, simulation and visualization software and services. • Design, implement, and test new software components for major releases and approve them finally. • Design user defined and daily uses of reports according to their requirements. • Graphical representation of data in different mode for upper level management to make future plans and marketing strategy Show less