Sql Server Windows
Resume:
Bernard L. McSmith, MCSA ****, Security+, Network+
**** ********* *****., *******, ** 30228
email: **************@*****.***
MS-SQL DATABASE ADMINISTRATOR
HA DR ALWAYSON TUNING ETL BACKUP & RECOVERY MIGRATION PARTIONING
Summary
Process driven Professional who specialize in the management of data for strategic business growth. Having provided management and support for military database systems to include backup, recovery, capacity planning and data migration from different database platforms. Having knowledge and training of 2005, 2008R2, and 2012 MS SQL. Understanding of ETL processes (SSIS), Performance tuning, backup and disaster recovery. Provided technical support for end users to help navigate database systems to track parts and produce cost analyst reports (SSRS) to commanders in extreme combat environments. Ability to multi-task and change course of planned action when new information is introduced. Team player who can function in a team environment or on an individual basis. Strong work ethic, dependable, and initiative. An individual who always takes ownership of given task and responsibilities. Always seeking new challenges and staying current with ever changing technologies.
Area of expertise/Core competences
Experience in Database Administration in SQL Server
Installation, configuration, and upgrade of Microsoft Windows Server 2003, 2008r2 and 2012
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Configuring and setting up windows Server Failover Clustering Environment Strong.
Ability to detect and troubleshoot SQL Server related CPU, memory,I/O, disk space and other resource contention.
Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Administering Windows Server 2003, 2008r2, 2012
Experience with BMC Remedy for incident, problem and asset management (including BMC Patrol)
Experience with Windows environment, VM
Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development - ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)
Performed Windows Software installs/upgrades, monitoring/alert configuration
Carry out Windows Server Performance tuning, Security of data - and physical security of the servers themselves
Manage the production and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity on SQL Server 2008 R2, 2012 and SQL Server 2014.
Tables partitioning, file and file-group management, Knowledge of High Availability of database servers using Database mirroring, replications, and Log Shipping.
Design and implement 2005, 2008 R2, 2012 and MS SQL 2014 databases for mission-critical business.
Experienced on Disk and Server configuration through Raid for SQL Server.
Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
Develop and modify stored procedures, queries, triggers, views, indexes, and functions to handle business rules, history data and audit analysis.
Use Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tools of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
Configure and support SSIS and SSRS for 2005, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014
Troubleshoot databases and custom application issues for 2005, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014
Generate the weekly, monthly, and quarterly report by using SQL Standard Report.
Create reports that ran daily for jobs running in SQL Server Agent.
Experienced with monitoring and troubleshooting in 24x7 operations.
Professional Job Experience
Step A/V, MSSQL DBA/Network Administrator (August 2014 – Present)
Union City, GA
Worked with a team of 10 staff in the development, design, and implementation of new applications and changes to existing hardware systems and software packages, resulting in increase in efficiency and return on investments for clients
Create, assign, accept and manage all incidents in BMC Remedy
Responsible for Windows troubleshooting of all incoming incidents and performs requests for service.
Managed environment and system configuration changes and application of problem management upon available skills and experiences.
Carry out Windows Server Health Status (Network Connectivity, Hardware Health Status)
Managed OS Health checks (Disk Usage, CPU and Memory Monitoring)
Migrating Databases from different platforms like SQL Server 2000 to 2005, 2008, 2012 and 2014.
Installing and configuring database software, associating database tools and performance monitoring software.
Performing database/infrastructure physical design, database upgrades & applying software patches to databases as per application/client requirements.
Estimating disk storage requirements for database software, database files & database administration needs and general capacity planning.
Developing and maintaining scripts, utility jobs and implementing needed software for database maintenance.
Implementing and managing database clustering, failover and load balance technologies as per client requirement.
Developing, testing & implementing a robust database backup and recovery strategy with client assistance.
Requesting refreshes pre or post restore activities (e.g. data loads).
Conducting root cause and analysis for database incidents and problems.
Participating in designing, testing and implementing an enterprise Disaster Recovery Plan.
Monitoring data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
Suggesting Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
Developing and executing scripted changes requests in accordance with change control procedures.
Conducting research and collaborating with vendor if necessary for additional patches.
Researching, reviewing and recommending for preventive maintenance.
Interfacing with database vendors & client technical support teams to isolate & resolve database related problems.
Handling Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
Managing Databases of more than 6 TB replications and disk cloning.
Expertise in MSSQL SERVER Database Administration.
Setting up Log Shipping, MSSQL Mail, SMTP, always On, Clustering, Mirroring and Replications
Creating, administering & maintaining SQL Server Databases (Production, Development, QA, Test and Staging Env.) for various groups such as Developer, QA, DA and User and ensuring the Availability of the Database Server in a 24X7 Environment.
Scanning the data pages, Indexes and checking the storage space used by each table.
Managed security by defining roles and rights.
Handling Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
Monitoring the database server performance and if required go for tuning of the TSQL queries, Stored procedures
QinetiQ-NA, Network Administrator/ MSSQL DBA (June 2006 – August 2014)
Kuwait/Afghanistan/Iraq/Germany
Responsible for Windows troubleshooting of all incoming incidents and performs requests for service.
Managed environment and system configuration changes and application of problem management upon available skills and experiences.
Management and Carried out Resources planning, operations and cooperation on application of projects for continual environment and procedure improvement.
Carry out Windows Server Health Status (Network Connectivity, Hardware Health Status)
Managed OS Health checks (Disk Usage, CPU and Memory Monitoring)
Managed Backup status (on applicable servers)
Configuring and setting up of Disaster Recovery (DR) and High Availability (HA) using Alwayson High Availability solutions for customers
Performs Windows analysis, acquisition, installation, maintenance, and upgrade of server/computer hardware, operating systems, and software utilities; Manage the deployment, upgrades, and maintenance of, servers, hardware, software, desktop operating systems, and printers
Provide system administration of hardware, operating systems, application software, and overall solutions
Maintain server backup systems and monitor system performance
Creating and managing Windows Server clustering.
Design, implement and administer High Availability solutions, (clustering, log shipping mirroring and replication)
Provide 24/7 remote support to SQL Servers on customer sites of various companies to prevent downtime
Writing, debugging, and tuning T-SQL, ETL and Stored Procedures for system performance
SQL Server database physical model creation and implementation (data type, indexing, table design)
Development, deployment and management of SSIS, SSAS, SSRS and publication for end users using given KPIs and KPAs
Using SQLSentry and light-speed application for optimizing queries and database performance
Setup and administering SQL Server Database Security environments using profiles, database privileges and roles to prevent data theft and increase data integrity
Database maintenance, replication and tuning
Migration of systems data from different databases and platforms to MS-SQL databases
Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers
Designing, Implementing and maintaining database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, rules, defaults and complex SQL statements.
Generate complex stored procedures and functions for better performance and flexibility
Ensure database performance monitoring and tuning is regularly accomplished
Understanding of backup and restore strategies and Disaster Recovery solutions
Implement security policy design for current and new applications
Load data into oracle and SQL database from DB2 extracts using SQL loader
Responsible for maintenance, Backup & Recovery, testing, alerts (job failures, database & server capacity, etc), and database integrity checks
Review logs, update database statistics and index management
Troubleshoot application performance issues, database maintenance & configuration, patching, and upgrading
Security, auditing, configuring, documenting, enhancement & corrective changes, emergency changes
Participate in DBA On-call monthly and document environments and processes where applicable
Work with other DBA team members and various application teams
Auditing systems and developing standards and implementation of best practices for performance and clarity
ITT Corporation. Desktop support Administrator (November 2002 – May 2006)
Kuwait
Maintain daily performance and accountability of several end devices running WindowsXP/Windows7 OS
Managed Backup status (on applicable servers)
Performs Windows analysis, acquisition, installation, maintenance, and upgrade of server/computer hardware, OS, and software utilities; Manage the deployment, upgrades, and maintenance of servers, hardware, software, desktop, laptops, and printers.
Analyzes operations statistical data and reports to ascertain functional trends, conformance to standards and directives and efficiency of operations.
Provide system administration of hardware, operating systems, application software, and overall solutions
Mentored new employees and vendors to internal infrastructure.
Assisted with migration from ULLG database platform to SAMS database platform
Provided incident resolution.
Responsible for Windows troubleshooting of all incoming incidents and performs requests for service.
Upgrade onsite computers to include desktops and laptops
Provided network management of onsite routers and switches
Tracked incoming repair parts through military shipping and tracking database
Entered repair time per repair job into SAMMS maintenance database
Performed daily backups to primary and secondary storage devices
Restored backups from failed equipment to new out the box equipment
As required, assisted with modifying database policies, guidelines, standards, procedures, and documentation.
Education
DeVry University, A.S. Electronic Computer Systems, Applied Science
DeVry University, B.S. Business Management (Currently Perusing)
Austin Community College, Electronic Technology-Technician
Central Texas Community College, General studies
Professional Certifications
MCSA SQL 2012
Security+
Network+
A+
Professional Memberships
Technology Association of Georgia (TAG)
Military Experience/Honorable Discharge
US Army
Heavy Equipment Technician
Multiple Duty Stations
Fort Sill, Oklahoma
Camp Eagle, Korea
Camp Comanche, Bosnia and Herzegovina
Fort Hood, Texas
Awards
Army Overseas Duty Medal
Army Commendation Medal*2
Awarded Army Achievement Medal*2
Awarded Good Conduct Medal*3
Major Clients Supported
U.S.Army, U.S.AirForce, U.S.Marines, Lockheed Martin, Applied Materials, CSA LTD, ITT industries, Westar Aerospace Defense Technology Systems, QinetiQ North America Technology Systems.
Contact this candidate