PROFESSIONAL SUMMARY:

• Perform database administration for SQL Server 2008R2 and SQL Server 2017 in a Windows 2010
• Support several web based applications for the Veterans Affairs Health Eligibility Center.
• Work with application development teams to design, and review designs for new databases, or changes to existing databases.
• Evaluate current technology and recommend tools/processes for improving availability, reliability, and stability and work efficiencies
• Write procedures and documentation to improve and resolve known issues.
• Maintain and update share point databases
• Require some after hour and weekend maintenance of the databases and servers.
• Write Sql and store procedures to troubleshoot and modify and automate processes.
• Knowledge of Microsoft Azure Sql Database. Migrate from local on premises server to cloud environment.
• Knowledge of Installing and Configuring a Database Platform on Azure or any other cloud platforms.
• Knowledge of implementing High Availability and Disaster Recovery (HADR) based on requirements for its workload (Using Log - Shipping, Mirroring, Always-ON for HA and DR)
• Knowledge of Implementing SQL Server / Azure cloud technology. Installing and monitoring sql server databases.
• Knowledge of Implementing SQL Server / AWS cloud technology, Installing and monitoring sql server databases.
• Develop jobs to run nightly using Idera SQL management tools.
• Migrate databases from development environment into a production environment.
• Monitor and create DTS packages and SSIS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Create backup scheme for database and transaction logs to ensure databases and transaction logs are being backed up on a daily basis.
• Setup and monitor transactional replication.
• Maintain database design and architecture.
• Maintain database security for all production and development environments.
• Participate in a 24X7 pager rotation for database and application support.

TECHNICAL SKILLS:

Operation Systems: Windows 10 and windows server 2016

Monitoring Tools: Citrix Server, Net IQ App Manager and Net IQ SQL Management Suite, Idera management tools. SQL diagnostic manager.

Relational Databases: Microsoft Access, SQL Server 2000, SQL Server 2005, Sql Server 2008, Sql Server 2008 R2, Sql Server 2012, SQL Server 2016, SQL Server 2017 Microsoft Azure Sql Database, Oracle 7.3, Oracle 8.0i, Oracle 9.i and SQLbase (Centura Product)

Programming Languages: SQL, PL/SQL, SAL, Visual basic, SQL Windows and Transact SQL, Powershell.

GUI Tool: .Net Framework SSIS packages, SSRS, Microsoft Access, Quest Reporter Crystal Reports, Erwin, ALL Fusion and Visual Studio.

Business Packages: MS Project, sharepoint 2010, Office 4.2, Source Financial, Source 550 Payroll application, Visual Manufacturing and Visual Financial.

Cloud Technology and Services: Azure Sql Database and AWS (RDS) Sql Database

PROFESSIONAL EXPERIENCE:

Confidential

Sr SQL Server Database Administrator

Responsibilities:

• Perform database administration for SQL Server 2005 and SQL Server 2008 in a Windows 2003
• Support web based applications for the Department Of Defense school system formally known as SMS Chancery Software..
• Maintain and install Crystal Reports.
• Installation and maintenance of IIS on all SMS Web Servers.
• Monitor database, OS level, error logs, Chancery SMS error logs and SMS application to ensure smooth daily operation of SMS.
• Install SMS on sand server for testing of new versions and .
• Communicate with the DBA’s and technical personnel in Europe and Okinawa to assist with issues and share knowledge of School Management System.
• Communicate with Chancery on all issues related to database stability and upgrade issues.
• Write procedures and documentation to improve and resolve known issues.
• Require some after hour and weekend maintenance of the SMS servers.
• Write Sql and store procedures to troubleshoot and modify and automate processes.
• Develop jobs to run nightly using Idera SQL management tools.
• Migrate databases from development environment into a production environment.
• Monitor and create DTS packages and SSIS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Create backup scheme for database and transaction logs to ensure databases and transaction logs are being backed up on a daily basis.
• Setup and monitor transactional replication.
• Maintain database design and architecture.
• Maintain database security for all production and development environments.
• Create and update on a on going basis a disaster and recovery plan

Confidential

SQL Server Database Administrator

Responsibilities:

• Perform database administration for SQL Server 2000 and SQL Server 2005 in a Windows 2003 Cluster environment.
• Support web based applications.
• Support People Soft Financials application for accounting department.
• Resolve connectivity and functionality issues.
• Schedule backups and restore databases. Maximize performance for 25 production databases ranging in size from 10 gigs to 1.7 terabytes.
• Schedule jobs to run nightly using Idera SQL management tools.
• Migrate databases from development environment into a production environment.
• Monitor and create DTS packages and SSIS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Setup and monitor snap shot replication.
• Maintain database design and architecture.
• Maintain database security for all production and development environments.
• Scheduled backups and restored databases. Maximized performance by tuning 300 production databases ranging in size from 10 gig to 1.4 terabytes.
• Scheduled jobs to run nightly using SQL server agents.
• Migrated databases to new location.
• Tested third party software for evaluation for company use.
• Created DTS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Maintained database design and architecture.
• Maintained database security for all production and development environments.

Confidential

SQL Server Database Administrator

Responsibilities:

• Scheduled backups restored databases and did performance tuning.
• Set up Net IQ; monitored network and databases and created customized reports.
• Tested Microsoft SQL Server 2002 Reporting Services for management.
• Developed and designed databases. This consisted of designing tables, creating indexes, and normalizing database to maximize performance.
• Supervised team members in database design.
• Migrated databases to new location.
• Tested third party software for evaluation for company use.
• Created DTS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Set up and monitored Net IQ for alerts and system reports.
• Scheduled jobs to run nightly using SQL server agents.
• Wrote stored procedures and triggers to maximize performance.
• Handled all database security issues.

Confidential

SQL Server Database Administrator

Responsibilities:

• Performed database administration for SQL Server 2000, SQL Server 7.0 and SQL Server 6.5 on Windows 2000 platform; supported in-house and web based applications.
• Responsible for scheduling backups, restoring databases and performance tuning for 30 production databases to maximize performance.
• Scheduled jobs to run nightly using SQL server agents.
• Migrated databases to new location.
• Supervised team members in database design. Wrote stored procedures and triggers to maximize performance.
• Tested third party software for evaluation for company use.
• Created DTS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Set up and monitored Net IQ for alerts and system reports.
• Developed and designed databases. This consisted of designing tables, creating indexes and normalizing databases to maximize performance.
• Created custom reporting for management using Crystal Reports.
• Handled all database security issues.

Confidential

SQL Server Database Administrator

Responsibilities:

• Performed database administration duties on SQL Server 2000, SQL Server 7.0, Windows NT and Windows 2000 Platform.
• Supported web based applications.
• Responsible for scheduling backups, restoring databases and performance tuning for 10 production databases to maximize performance.
• Scheduled jobs to run nightly using SQL server agents.
• Worked closely with developers to create and design databases. Designed tables, created indexes and normalized database to maximize performance.
• Setup snap shot replication for reporting team.
• Responsible for maintaining Microsoft Access databases.
• Set up test environment (databases) for developers.
• Replicated tables nightly for updates.
• Wrote stored procedures that updated tables with current information.
• Scheduled database consistency checks to maximize performance of databases.
• Created and positioned reports to web pages using Complicity software.
• Created DTS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Set up database security to protect the integrity of data.
• Created custom reports using Transact-SQL to enter data in an Excel spread sheet.
• Supervised team members in database design.
• Migrated databases to new location.
• Tested third party software for evaluation for company use.
• Created DTS packages to transfer data into tables from spread sheets or to transfer data from one database to another.
• Set up and monitored Net IQ for alerts and system reports.
• Scheduled jobs to run nightly using SQL server agents.
• Wrote stored procedures and triggers to maximize performance.
• Handled all database security issues.
• Handled all database security issues.

Confidential, Atlanta, Ga

Sql Server Database Administrator

Responsibilities:

• Responsible for supporting Payroll processing software for 30 thousand users. Working with software developers to help resolve and location issue dealing from software integrity to reporting bugs in the product.
• Maintain databases and applications on Window NT platform In a SQL Server 6.5, 7.0 and 2000 environment.
• Responsible for backup and recovery and migration of databases as well as tuning databases to maximize performance for over 100 databases with over 2000 users in an ASP hosting environment.
• Responsible for looking over triggers and store procedure for enhancement of performance on Window NT platform.
• Responsible for running maintenance plan on database Create DTS packages for transferring data from database to remote database also import data from spreadsheets to tables in database. Performance tuning of database to maximize performance, which also includes optimizing queries for better performance. Monitor user session using Citrix.
• Responsible for enforcement of security rules setting up security groups, views and roles to protect integrity of the database and application.
• Responsible for upgrading databases from 6.5 to 7.0. also from 7.0 to 2000.
• Responsible for building custom reports utilizing Crystal Reports.
• Responsible for creating custom security that is integrated with Crystal Reports
• Responsible for scheduling database consistency checks to maximize performance of databases.
• Responsible for handling all database security issues
• Responsible for monitor Oracle 8 i for performance.

Confidential, Atlanta, Ga

Sql Server Database Administrator

Responsibilities:

• Responsible for various databases administrative functions in a manufacturing environment, developed software application and design reports for management. Duties also included:
• Responsible for supporting Visual Manufacturing and Financial application for automotive department and the accounting department issues ranging from showing the supervisors how to schedule jobs and track inventory to resolving problems that user would have from the accounting department.
• Monitor SQL Console to enhance performance on Windows NT 4.0 platform.
• Writing and running scripts using Sql talk to communicate with the database to enhance performance, add tables, update, insert data into tables, and check integrity of the database and database tuning.
• Develop reports for management utilizing Quest Report Writer
• Schedule daily backups and recovery of database.
• Create views and roles for database security. Responsible for monitor Oracle 8 i in a production environment.

Confidential

Oracle Software Developer

Responsibilities:

• Designed and developed a relational database management system using Oracle 7.3.
• Provided activity status tracking ability and performed functional and system requirement analysis.
• Developed an object based logical (entity relation) model and created the physical database on Windows NT Server.
• Developed software using Developer 2000 (forms 4.5, Reports 2.5 and Graphics 2.5) as front end GUI Tools and Oracle 7.3 environment on the server side.
• Created server side objects such as tables, indexes sequences, stored procedures functions database triggers and packages in PL/SQL using SQL*PLUS to maintain data integrity.
• Created window-style forms integrated with reports and graphics allowing assignment of employees to different work orders and tracking the status of any activity.
• Resolved several critical tasks by PL/SQL coding.
• Created numerous PL/SQL procedures, triggers and packages on the client and server sides to enforce business rules.
• Develop reports using Developer/2000 Report Builder to supply management with daily production reports.