Customer Service Sql Server

Paolo Aizon

Cell: +639*********

Email: *************@*****.***

Summary of Key Skills

Problem Solving Skills: Ability to assess problems and research solutions to keep the business computer connected and running, and providing solutions to improve business process.

Communication and Customer Service Skills: Able to communicate comfortably in all levels of business user in resolving technical problem and providing excellent customer service satisfaction. Experienced in training users on how to use the IT related equipments.

Time Management Skills: Performing routine system backups, documenting the configuration of the system, ensuring that the network infrastructure is up and running, and prioritizing each work load in a timely fashion.

Database Administration: Highly experienced in installing and configuring SQL Server, maintain instances and database, optimizing data and troubleshooting problems, creating database objects, working with data by querying, and manage data by performing backup/restore strategy.

System Administration: Highly experienced in providing technical needs with emphasis on security, OS configuration, DNS, group policy, hardware support, file storage, web servers, server virtualization, domain controllers, active directory, and mail servers.

Technical Skills and Knowledge

Networking/Technology: TCP/IP (Addressing & Subnetting), DHCP, DNS, FTP, DSL/Cable, cabling, SMTP, POP3, IMAP, NAT, VPN, RRAS, HTTP, SSH, LAN/WAN, MS IIS, Firewalls, VoIP

Hardware: Dell Server, miscellaneous PC hardware, IDE hard drives, SCSI devices, IP Camera (Foscam/Apexis/Compro), IP Phone (Grandstream), Biometrics (Anviz), Switches and routers (Linksys/Dlink/HP), Wireless CPE (Linksys), printers (Epson/Canon/HP), scanners, POS peripherals, Cyberoam

Operating Systems/Softwares/Solutions: Windows Server 2008/R2/2012, Windows XP/7/8, Hyper-V, Exchange Server 2013, Clustering, Load Balancing, Active Directory, Distributed File System, File Server Resource Manager, System Center 2012

Languages/Databases: ASP.Net, VB.Net (Desktop Apps) – Visual Studio 2005/2008, PHP, HTML, MSSQL Server 2005/2008/2012, MySQL 5

Personal Attributes

Friendly and outgoing

Flexible and adaptable with a ‘can do’ attitude

Able to learn quickly and a keen eye for detail

Analytical thinker with solutions focused approach to problems

Ability to work under pressure and complete task in a timely manner

Employment History

Systems/Database Administrator March 2013 – Present

Denim Ignition Clothing Inc., Philippines

Responsibilities

Install and configure servers including the roles and features; design, install and administer active directory infrastructure; create and manage group policy.

Deploy, design, and maintain server infrastructure; design and configure file and print services; configure network services/security including firewall and access.

Configure and manage high availability infrastructure; configure file and storage solutions; implement business continuity and disaster recovery.

Perform upgrades and maintenance for servers, desktops, laptops & peripherals including applying patches to protect the infrastructure; monitor the network and server performance to determine whether adjustments need to be made, and to determine where changes will need to be made in the future.

Design and manage exchange infrastructure; install, configure and manage client access, mailbox role, and transport.

Create database objects by creating and altering tables; creating and modifying constraints.

Create a tuning and maintenance strategy for indexes and statistics.

Working with data by querying SQL server and implement sub-queries; modify data by creating and altering stored procedures.

Plan and install SQL Server; maintain instances and databases; optimize and troubleshoot database server by identifying and resolving concurrency problems, by collecting and analyzing troubleshooting data, and by auditing SQL Server instances.

Manage data by configuring and maintaining a backup/restore strategy; by implementing and maintaining indexes, and by importing and exporting data.

Implement database security by managing logins/users and roles; by managing database permissions, by troubleshooting security, implement and monitor database high availability using AlwaysOn feature.

Lead team in troubleshooting and performing root cause analysis for resolving problems that have multiple dependencies (PC workstations, servers, network, databases, software products, telephony, etc).

Respond to help desk requests made by office and remote users needing assistance with software packages/network connectivity.

Confer with network users about how to solve existing system problems.

Develop documentation and participate in planning meetings, often acting as liaison between application developers, customers and other IT team members.

Prepare users by designing and conducting training programs; providing references and support.

Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.

Achievements:

Successfully deployed new infrastructure using server 2012 with the following roles and features on each server.

oActive Directory Domain Services (Group Policy, Central Access Policy)

oActive Directory Certificate Services (Certification Authority)

oHyper-V for virtual machines with failover clustering for high availability

oRemote Desktop Services for thin clients

oVolume Activation Services for activating server 2012 and windows 8 machines

oFile and Storage Services (DFS Namespace, File Server Resource Manager)

oPrint and Document Services (Print server)

Successfully deployed and administer Exchange Server 2013 for organization’s mail server

Successfully deployed and migrated from SQL Server 2008 to SQL Server 2012 including administering the company’s databases

Successfully deployed and administer virtual machines using System Center 2012 (Virtualization, Clustering, Operations, Configuration) for the small datacenter

Converted existing workstation into thin clients using freerdp to be able to access the remote desktop services

Electronic Operator October 2012 – January 2013

Quickcircuit Ltd, New Zealand

Responsibilities

Connect component lead wires to printed circuit board

Assemble electronic parts into on complete component

Install finished assemblies or subassemblies in cases and cabinets

Perform other duties as may assigned

Achievements

Have assisted the team in providing better solution and procedure to increase production output

Systems Administrator August 2008 – June 2012

Emerald Garment Manufacturing Corporation, Philippines

Responsibilities

Supporting customers to Install, assemble, and configure new servers, workstation computers, and other ICT related peripherals as required by the business unit

Perform all aspect of systems administration which includes maintenance, troubleshooting, and monitoring of all server, network infrastructure (broadband internet), network equipment (fixed line and wireless) and devices to ensure system availability and continued performance in head office and all retail stores

Perform infrastructure design including the configuration, updates, patches, performance tuning, and maintenance of servers and desktops not limited to dns, dhcp, active directory, virtualization, file and storage services, and other applicable services to ensure system availability and continued performance.

Quickly respond to customer and resolve hardware and network failures. Ensure all customer servers, and workstation computers, and other computer services/systems are maintained and operational at all times and being on call ensuring remote sites are operational. Ensure all customer network infrastructure including internet connectivity is up and running at all times.

Train computer users on how to use the ICT related peripherals to minimise the contributing cause of the problem.

Support and Assisting customer in hardware and software upgrades, and patches ensuring network and database security is provided.

Perform backup of all various IT platforms and data storage with high availability solutions.

Assist in planning and implementation of new projects.

Achievements:

Successfully deployed windows server 2003/2008 domain controllers for 100+ workstations with user and computer security using group policy including automatic software installation, and domain and server isolation as added security

Installed and deployed domain namespace file servers that help ensure quick, efficient, and reliable management and access to business data with file replication solution

Installed and configured pfsense as firewalls, internet gateways with web content and mail filtering to secure the internal network from intruders and providing safe internet browsing

Successfully connected the head office to its remote branches via internet and vpn connection providing services like ip cameras remote viewing, voip, data integration and remote management

Documented the configuration of different computer system and network infrastructure to provide quick troubleshooting

Analyst Programmer/Database Admin June 2003 – July 2012

Emerald Garment Manufacturing Corporation, Philippines

Responsibilities

Perform system analysis to produce high quality computerized information system

Provide database design and development

Develop numerous desktop and web applications

Improve SQL Stored procedures to build a regular and complex report

Install and configure SQL Server and its related tools.

Monitor and optimize the performance of SQL Server by using engine tuning advisor, SQL Server profiler, and system monitor.

Monitor and troubleshoot database servers.

Administer existing enterprise databases including the analysis, design, and creating of new databases.

Maintain a database server by planning for backup and recovery of SQL server, and by using maintenance plans.

Monitor and administer database security which involves adding and removing users, checking database and server audits to ensure security.

Communicate regularly with technical and application staff to ensure database integrity and security.

Perform all aspects of database administration to ensure users can access data concurrently.

Participated in the development of company website, creating web pages and content management

Trained users on how to use the new or modified computer application

Achievements

Increased employee productivity by introducing new process and procedure that eliminates work duplication

Reduced licensing cost in purchasing point of sales by developing its own system

Successfully migrated and configured MSSQL Server 2005/2008 for all company’s backend database to increase performance, and MySQL for Human Resource Information Systemzand Payroll System providing replication solutions for all databases

Analyst Programmer July 2000 – June 2002

Aleson Shipping Lines, Inc., Philippines

Responsibilities

Perform various computer programming and system analysis activities, including coding programs and troubleshooting of computer systems to maintain and control the use of computer systems.

Write, analyze, review, and rewrite programs.

Work with personal computers and local area networks

Consult with computer operators to define and resolve problems in running computer programs.

Achievements

Developed ticketing, bill of lading, receivables, and payables system thus increasing employee productivity.

Qualifications

Bachelor of Science in Computer Engineering 2000

Western Mindanao State University

Bachelor of Engineering at Level 7 2010

New Zealand Qualifications Authority

Certifications

MCSE: Microsoft Certified Solutions Expert (Server Infrastructure)

MCSA: Microsoft Certified Solutions Associate (SQL Server)

ITIL v3 Foundation Certified

Trainings and Seminars

Software Testing Boot Camp, 2012 Health and Safety Seminar, 2012

Auckland, New Zealand Auckland, New Zealand

Personal Interests

Video editing for occasions, outing, playing basketball, watching movies and reality shows, playing online games

Referees

Available on request

Contact this candidate