SUMMARY:

• Microsoft Certified Systems Engineer (MCSE) and computer support professional skilled in all facets of desktop and network systems planning/design, programming, installation, configuration and maintenance.
• Skilled supervisor, highly proficient in database modeling, implementing network security protocols, and evaluating/monitoring system and network performance.
• Innovative and analytical individual with exceptional project management, organizational and communication skills.
• Solid interpersonal and communication skills as well as a demonstrated ability to manage multiple projects.
• Microsoft Certified Database Administrator (MCDBA)
• Microsoft Certified Systems Administrator (MCSA)
• Microsoft Certified Systems Engineer (MCSE)
• Cisco Certified Network Associate (CCNA)
• Microsoft Certified Professional (MCP)
• Citrix Certified Administrator (CCA)

TECHNICAL SKILLS:

Deployment: Mass deployment of windows XP using Remote Installation services.

Protocols: TCP/IP, IPX/SPX, Net BIOS

Operating Systems: MS - DOS, Windows 3.1, Windows for Workgroups, Windows 95/98, Windows NT 3.51/4.0Novell Netware, Windows 2000, Windows XP, IBM OS/400, Windows Server 2003, Windows server 2008.

Programming Languages: Visual Basic, Hypertext Markup Language (HTML)

Software: MS Office (Word, Excel, PowerPoint), Proxy software, Trading Applications

Networking Experience: TCP/IP Configuration, TCP/IP Troubleshooting, Internet Mail Routing, Network Configuration,

Network Troubleshooting:

PC Experience: Software installations, Hardware Configuration, PC Repair

NT Experience: Enterprise Networking, Domain Model Planning, Workstation Troubleshooting, Server Troubleshooting

Business support: Customer Technical Support, Quality Assurance, Disaster Recovery, Staff Technical training

Databases: SQL6.5/7.0, SQL 2000 SQL 2005& 2008 Oracle 8i, 9i and 10g

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL server DBA

• Responsible for administration and support of a large complex environment with 500+ Microsoft SQL Server instances on a variety of Windows versions.
• Responsible for administration, optimization and maintainenance of SQL Server 2008 r2 and newer database environments running on Windows platforms;
• Support internal and external clients using our kCura Relativity infrastructure and database servers.
• responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment, optimization and implementation of new technologies.
• Diagnose SQL Server database issues, including performance and data integrity issues.
• Responsible for Planning/advisory/validation of all database installations, patches and upgrades.
• Responsible for after hours support for SQL server related issues by taking part in on-call rotation.

Confidential

Senior SQL Server DBA

• Senior database administrator responsible for installation, configuration and maintenance of over 300 SQL servers in five different sites. These servers range from SQL server 2000, SQL server 2005, SQL server 2008, SQL server 2012 and SQL server 2014.
• Experienced in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS (SQL Server Analytical Services) and OLAP (Creating Cubes) including interfaces with BIDS.
• Participate in On Call rotation for SQL server issues after hours.
• Installed and Configured Always On High Availabilty Groups and SQL server Clusters on SQL server using SQL server 2012 and SQL server 2014.
• Disaster Recovery Planning, Execution and Testing at remote sides.
• Responsible for Encryption of sensitive client data using TDE.
• Solid knowledge of Windows environments.
• Responsible for Technical documentation of SQL server processes and procedures.
• Configuring and managing Clustered SQL server environments, database mirroring, performance tuning and replication.
• Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

Confidential

Senior Network Engineer

• Install configure and manage VMware ESX/ESXi 3.5/4.1/5.0 environments
• Install configure and maintain Dell MD3000i and EMC Clariion CX SAN systems.
• Configure and maintain Active Directory environment comprising eight geographical sites
• Responsible for Exchange 2007/2010 installation, configuration and maintenance including routing, switching, Ironport devices and Cisco ASA firewall management.
• Responsible for Disaster Recovery planning, testing and implementation for all Bank IT services and deliverables.
• (SAN) Storage Administration including provisioning, fabric switch zoning and performance monitoring.

Confidential, K.C

SQL Server DBA

• Managed 40+ SQL Servers with over 40 terabytes of data. Responsible for SSAS, SSRS and SSIS setup and management.
• Responsible for disaster recovery planning for SQL Servers including SQL Server
• Replication to Disaster Recovery (DR) sites, Database mirroring, SAN to SAN Replication.
• Installed configured and managed SQL 2005 and SQL 2008 Clusters running on Windows Server 2008 and 2003 enterprise systems.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Storage provisioning and administration of EMC SAN (CX-240) Clariion Array units.
• Fabric zoning, Brocade switches management
• Responsible for backups/restores, monitoring SQL uptime, designing, maintaining SSIS packages, index tuning and query optimization.

Confidential, K.C., KS

Systems Engineer

• Install, configure and maintain Active Directory infrastructure.
• Strong understanding of Storage Area Networking (SAN) technology, including storage provisioning, LUN management, zoning, performance management, and volume management.
• Install, configure and manage both P-class and C-class chassis HP blade systems.
• Install, configure and maintain VMware ESX 3.0/4.0 environment and virtual servers.
• Install, configure and manage Windows hyper-v and their Virtual servers.
• Install and configure Microsoft System Center Operations Manager and Office Communications server suite.

Confidential, Lenexa, KS

Systems Engineer/SQL DBA

• Responsible for designing, installing and maintaining enterprise network infrastructure comprising Windows 2000,XP, 2003,Cisco routers and switches, Microsoft SQL 2000& 2005, Microsoft Exchange 2000 and 2003 servers.
• Advanced skill sets dealing with the setup, configuration, security, deployment and troubleshooting of Windows 2000 and 2003 servers.
• Design and build solutions utilizing DTS as an enterprise ETL tool. Build DTS packages that populate critical systems reporting marts and exception engines.
• Perform DBA responsibilities including database backups and restores, performance tuning and monitoring, database scalability, redundancy and integrity, replication.
• Responsible for the Evaluation, supervision and mentoring of junior staff.
• Managed all call center IT operations involving 3000 plus employees.
• Participated in several SQL server upgrades.
• Responsible for Convergys Corporation and Encore Receivable Management network integration projects.

Confidential, Overland Park, KS

SQL Server DBA

• Design, implement and support data warehousing and reporting services for all databases.
• Perform data modeling and design appropriate data structures for datamarts and data warehouses for SQL server databases.
• Upgraded a troublesome 15-server NT 4.0 network to a robust windows 2003 system employing terminal servers, routing and remote access, group policies, IP Sec policies, firewalls, SQL and Exchange servers.
• Design tables, databases, create and optimize queries and stored procedures for more efficient database access.
• Configure front end applications for optimal and secure database access using SSL encryption.
• Developing and managing DTS packages and perform disaster recovery operations.
• Analyze query execution plans and execute queries against linked servers.
• Install, optimize and administer oracle 8i, 9i and DB2 database servers.
• Developed stored procedures, DTS, UDFs, aggregates, replication, indexing, backup/recovery, DRI, SQL, XML, tables, views, linked servers, SQL Agent Jobs, cursors, and data modeling.

Confidential, Overland Park, KS

SQL DBA/ Systems Engineer

• Designed, build and maintained an offsite Disaster Recovery center for the entire Gold Bank network that covers Kansas, Missouri, Oklahoma and Florida states.
• Configured and implemented transactional SQL server replication from all Gold Bank branches to the Disaster Recovery center.
• Designed, tested and implemented a database system to record and audit entire Gold Bank’s software and application licensing, version and patch-level monitoring.
• Administer mission-critical payroll and billing databases.
• Used SQL profiler to analyze database performance and manage replication services.

Confidential, Kansas City, MO

IT Specialist

• Install, configure, monitor and backup/restore Microsoft SQL 2000 database servers.
• Analysis, reporting, maintenance and performance turning of databases to ensure high availability.
• Support all company SQL Server databases
• Install, configure .and troubleshoot file and print servers and Exchange servers on /off site.
• Responsible for testing and evaluating new hardware and software to ensure compliance with established company operational and security requirements.
• Responsible for LAN/WAN interconnectivity and monitor network resources, build user groups and establish network permissions.
• Coordinated and configured network services for implementation of WINS replication, DNS, DHCP, RRAS and VPNs.
• Ensure database integrity and availability by designing database maintenance plans.

Confidential, Kansas City, MO

Systems Engineer

• Architect SQL Server data structures, database schemas, database standards
• Developed and implemented effective SQL server and client solutions with expertise in system design, development and planning.
• Created, tested and tune data loading and cleansing processes, using a combination of Business Objects Data Integrator, Oracle and SQL Server views, functions and stored procedures, and Microsoft SQL Server replication.
• Designed and built, from the ground up, an NT Network consisting of 45 NT Domain controllers, 7 Exchange 5.5 servers, 10 Exchange 2000, 19 file and print servers, 27Win 2000 servers, 11 Win 2000 RRAS servers, 14 SQL 6.5/7.0 2000 servers.
• Responsible for development and implementation of comprehensive back-up procedure for LANs.
• Maintain network infrastructure consisting of Cisco hubs, switches, routers, firewalls plus links and patch panels.
• Load, configure and maintain laptop and desktop computers running Windows 95/98, NT 4.0, 2000, and XP.
• Responsible for troubleshooting all end user problems with applications, operating systems, hardware, network cards and cables, network printers, remote access and routing.