SUMMARY:

• With over 13 years in Windows and SQL Server Administration, Confidential has worked with Windows versions from NT 2000 to Windows 2016 and SQL Server versions from 2000 to 2016. His experience includes configuration and installation of windows and SQL Server, SQL job and patch management, troubleshooting performance issues on windows and SQL servers, tuning SQL queries, configuring log - shipping, mirroring, AlwaysON availability groups, replication, and virtual machines to be used for SQL Server. He has windows batch scripting experience, PowerShell, and Microsoft transact-SQL experience.

TECHNICAL SKILLS:

Technology/Applications: Bare-Metal and virtual machine administration; Microsoft Azure and Amazon Web Services (AWS).

Methodology: Microsoft related products

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server Database Administrator

Responsibilities:

• Responsible for the planning, development, implementation, utilization, monitoring, and administration of MS SQL Server Databases
• Interact with the customer and providing guidance and advise as it relates to the security, integrity, efficiency, and proactive maintenance of the databases
• Helps to establish and enforce written guidelines, rules and standards regarding optimal MS SQL Server DB operation
• Perform day to day and long-term monitoring of system health as it relates to database usage and performance
• Perform research into database performance issues and come up with solutions to address those concerns
• Respond to requests for data from clients in a timely fashion
• Perform database health checks using SQL profiler, performance monitor, performance counters and DBCC commands

Confidential

Sr Database Administrator

Responsibilities:

• Perform maintenance and tuning tasks on ten SQL Server 2012 servers
• Log Shipping
• Mirroring
• Replication
• Backup Strategies
• Monitoring Server performance
• Performance improvement suggestions for queries
• Index suggestions
• Deadlock investigations
• Query Tuning and data correction updates

Confidential

Sr Database Administrator

Responsibilities:

• Perform maintenance on over 25,000 instances of SQL Server, ranging from version 2005 to 2012
• Log Shipping
• Mirroring
• Replication
• Backup Strategies
• Shrinking data and log files
• Monitoring Server performance
• Performance improvement suggestions for queries
• Index suggestions
• Deadlock investigations

Confidential

Sr SQL Server Database Administrator

Responsibilities:

• Perform day to day operations functions including establishment of mirroring, log shipping, cluster configuration, backups and restores, and ticket requests for roughly 45 SQL servers
• Troubleshooting of performance issues in production and lower (dev/test/stage) environments for developers
• Trained developers to understand performance problems and ways to correct issues
• Established performance analysis/review with development teams for them to better understand their databases performance and how it affects other databases or servers within the environment
• Documentation on server/database configuration and layout

Confidential

SQL Server Database Administrator

Responsibilities:

• Perform backups, log shipping, mirroring, query tuning, index optimization, and other tasks on 2005 Servers
• Create SSIS packages for ETL processes and file system manipulation
• Design database schemas for new projects
• Review and modify previously existing processes for efficiencies

Confidential

SQL Server Database Administrator/Database Engineer

Responsibilities:

• Managed 44 production and 10 development SQL Servers 2005/2000 servers and one 2008 dev (CTP) box
• Established Log Shipping and Mirroring
• Replaced/Implemented Transactional replication (from merge)
• Created various archival processes
• Data Warehouse Integration
• SSRS Administration and development
• Created File Management processes (flat files, spreadsheets)
• Wrote procedures and SQL statements/jobs for auditing machine and job configurations
• Implemented SSIS over DTS and converted packages
• Established machine load/stress testing procedures
• Wrote stored procedures for applications and management
• Gathered information from Dynamic Management Views into central repository
• Used Idera SQL Diagnostic Manager, SQL SAFE (for backups) and Lumigent AuditDB (for log scraping/ field value auditing)
• Business Objects XI and Crystal Reports report creation and administration

Confidential

Database Administrator

Responsibilities:

• Develop stored procedures, DTS packages, and functions in T-SQL on a 40 server, 120 database environments for SQL Server 2000/2005
• Perform replication and log shipping functions for various banking and other service databases
• Optimization of functions for server space management and clustering/re-indexing, tracing queries, creating custom jobs and monitoring multiple databases’ performance statistics and providing maintenance work where necessary
• Provided deliverables to Sr. Management for projects including Customer Profitability Analysis as well as regulatory information requested by the Government’s agent
• Used Business Objects Data Integrator for some ETL operations, DTS for most, and SSIS for a few new processes

Confidential

Database Administrator

Responsibilities:

• Administrator for 4 client databases across the United States based on SQL Server 2000/2005
• Perform all tasks related to database administration
• Development in VB script; maintenance plans, backups, log shipping, archival, trigger management
• Utilized DTS for data migration and manipulation
• Provide ad hoc and customer support for metrics in all geographic areas
• Provide analysis of business metrics and present results to senior management
• Implemented paperless environment using automation of workflow and reduction of paper business requirements

Confidential

Business Analyst/Research and Analysis Supervisor

Responsibilities:

• Contributor: 2006 Texas Medicaid Provider procedures manual
• Directed implementation of Activity-Based-Compensation (ABC) program within claims services
• Performed all analysis related to production, quality and payment rates, etc
• Multiple claim process creations, automation initiatives incorporating efficiencies, workload distribution, manual refining and improvement
• Perform analysis, planning, establishment of requirements, functional modeling, development of procedures, development of functional architectures, databases, and other data as required by management for the claims services group.
• Provide direction to quality assurance and research personnel for claims processing and policy
• Provide instruction to key personnel as necessary on Six Sigma and quality tools
• Provide SQL query research and statistical production reporting using Microsoft Office, Business Objects, iSQL* Plus and TOAD software
• Created various databases for claim specific information (Access, SQL Server 2000, Oracle 10g)
• Created master QA database for housing adjudicator quality information (Oracle)
• Perform analysis of user needs to determine functional and cross-functional requirements for claims adjudication
• Perform allocation to identify required tasks for service requests and their interrelationships
• Root Cause - Corrective Action program analysis and associated graphs and charts
• Interfaced with other departments to represent the customer in conducting interoperability assessments, implementation and supportability procedures

Confidential

Supplier Quality Engineer

Responsibilities:

• Provided Business Improvement and Supplier Quality Assurance
• Refined a pre-established return material authorization process that was yielding a loss of $136,000 a year
• Reduced cycle time on processing by 20% with automation and yielded a cost savings of $130,000 a year with most incoming RMA’s being profit centers
• Re-engineered a First Article Inspection process that was yielding 1,283 incorrect FAI’s
• Improved to a process that automatically flags these FAIs in the ERP systems to indicate shipping status and inspection required
• Process was further refined to include new procedures for supplier submissions and customer submissions
• Reduced cycle time with automation and a cost savings of $106,000
• Established a Material Review Board (MRB) for discrepant material which cost $410,000 annually
• Created process to deal with product within 48hrs and inventory costs below $50,000
• All projects were initiated using six sigma/lean tools and methodology
• Reviewed Incoming First Articles from suppliers and submitted First Articles to customers
• Worked with Quality Department performing document audit via AGILE and ORACLE (ERP)
• Responded to internal discrepancies in assembly with outside vendor product
• Member of Material Review Board (MRB) dealing with discrepant material from internal and external suppliers
• Interpret blueprints as necessary for assembly and/or production personnel
• Designed more efficient operating methods and procedures
• Member of six-sigma team investigating all internal processes using SPC and pareto analysis
• Member of Global Supply Chain Management group dealing with outside vendors, procurement and logistics

Confidential

Quality Assurance Auditor

Responsibilities:

• Audit Business groups and departments based on ISO 9000 requirements
• Perform routine and non-routine audits of TSOP assemblies, systems and related processes
• Perform routine audits of individuals for conformance with quality requirements and procedures
• Perform machine qualification audits for manufacturing processes
• Generated appropriate information to be recorded on various data sheets
• Generated non-conformance material reports