PROFILE:

• To continue career within an employee focused company.
• Utilize my Information Technology skills in a multidisciplinary setting.
• Confident: strong leadership skills obtained through several development projects.
• Task Oriented: able to assess skills and prioritise responsibilities in a synergistic manner.
• Self - starter: driven through initiative working well independently or as part of a group.
• Articulate: well versed in research and presentation methods.
• Adaptive: able to change according to requirements of both project and client.
• Sensing: in tune with employer and employee needs.

TECHNICAL SKILLS:

SQL Server, Windows Server NT / / / 2016

SQL Server T: SQL, BI, SSIS, SSAS, SSRS, PDW/APS, AlwaysOn

Classic ASP / .NET Framework 1.0: 4.5

Visual Studio 7: 14

Oracle 8i / 9i / SQL Plus / PL/SQL

VB 6 / VB.NET / C# / JAVA

HTML / DHTML / CSC / JavaScript / VB Script / XML

Microsoft SharePoint / Access / Excel / Azure

ColdFusion / Dreamweaver

PowerShell 4.0 / 5.0

EXPERIENCE:

MS SQL Server Senior Database Administrator

Confidential, Raleigh, NC

Responsibilities:

• Supervising teams of offshore and mentoring junior DBAs
• Coordinate internal resources and third parties/vendors
• Design, maintaining and migrating data centers
• Providing High Availability and Disaster Recovery solutions based on various SLAs and other requirements
• Managing and maintaining data in all production and non-production databases and replication servers.
• Managing the design and distribution, performance, replication, security, availability and access requirements for large complex databases.
• Developing powerful techniques to prevent unauthorized access of sensitive data such as data encryption and masking.
• Designing and developing physical layers of various databases making use of advanced features such as partitioning.
• Handling testing, reporting, back-up and restores.
• Providing technical assistance and mentoring to staff in all aspects of database management.
• Consulting and advising application development teams on database design, security, query optimization and performance.
• Performing performance tuning by analyzing database and OS performance and implementing tuning and optimization recommendations.
• Optimizing physical model to ensure efficient and reliable database performance.
• Managing the upgrades and installs of DBMS software.
• Providing monitoring and capacity management of the database.
• Performing DB support activities in partnership with internal and external service providers.

MS SQL Server Database Administrator

Confidential, Cary, NC

Responsibilities:

• Ensure that all projects are delivered on-time, within scope and within budget
• Assist in the definition of project scope and objectives
• Develop a detailed project plan to monitor and track progress
• Establish and maintain relationships with third parties/vendors
• Create and maintain comprehensive project documentation
• Manage changes to the project scope, project schedule, and project costs
• Estimating the hardware requirements in order to meet current workloads and considering future growth of the company
• Installing, configuring, optimizing and troubleshooting SQL Servers and Windows OS
• Establishing and enforcing databases’ access levels and security through Active Directories and SQL Server Authentications
• Working with software engineers on establishing T-SQL coding standards and naming conventions as well as designing, developing and optimizing databases (tables, views stored procedures, constraints, triggers, indexing, functions, table statistics etc)
• Developing and implementing methodologies for examining and testing pre-release database changes
• Providing support for data analyst’s team working with large data sets utilizing SAS software
• Negotiating and establishing standards of data formats and exchange protocols with Government entities, Healthcare providers and Fiscal agents
• Automating data import and export between different companies utilizing SQL Server SSIS, SFTP, batch files and Windows Task Scheduler
• Evaluating and testing third party software to use with SQL Servers
• Monitoring SQL Servers performance real-time with SQL Server Profiler and Extended Events
• Designing and implementing data warehousing from multiple sources and data formats as well as data archiving
• Creating maintenance and backup plans
• Scheduling SQL Server jobs for executing daily tasks: backups, maintenance, updates and alerts
• Evaluating and applying SQL Server and Windows OS updates
• Configuring hardware RAID, CPU, Memory, Disk Space
• Handling healthcare records PHI, HIPAA compliance, data encryption and transfer
• Setting up SQL Server Development, Test, Staging, Production and Data Warehousing environments
• Planning, testing and executing SQL Servers upgrades

VB .Net/MS SQL Server Developer

Confidential, Cary, NC

Responsibilities:

• Designing, developing and maintaining an external Confidential web application.
• The purpose of the application is to allow the health care providers in North and South Carolinas to report their facilities’ beds availability on weekly basis.
• The agencies looking to place their patients are able to search through the date based on different criteria and then contact provides directly.
• The application is based on multiple roles on of which is a large administrative role where administrators are able to enforce business rules on providers, communicate with agencies and make announcement to all users issued by DHHS (United States Department of Health and Human Services).
• ASP.NET, C# (front end) with N-Tier architecture, T-SQL (database communication), MS SQL Server (database), DHTML, CSS, JavaScript (interface and client side forms validations) were utilized to provide functionalities and interface design.

AQUIP Review Project:

• Designing, developing and maintaining AQUIP Review (The Automated Quality Utilization and Improvement Program) desktop application for reviewing quality health care for the Community Alternatives Program for Disabled Adults (CAP/DA). The data is being gathered by agents in every county of North and South Carolinas and then reviewed by qualified administrative nurses at Confidential head office.
• This application is completely object-orientated making use of several design patterns (i.e. Model-View-Controller (MVC), Singleton, Factory Method, Observer, etc.). VB.NET (front end), MS SQL Server (database), ActiveReports for .NET (reporting services)
• Designing, developing and maintaining an internal Confidential web application. The purpose of the application is to allow the employees to search for the physician consultants qualified to provider different medical advises and reviews for trouble some cases. The administrative part of this web application allowed Confidential administrators to add, update and delete information related to the physicians’ specialties, qualifications and fields of expertise.
• ASP.NET, C# (front end) with N-Tier architecture, T-SQL (database communication), MS SQL Server (database), DHTML, CSS, JavaScript (interface and client side forms validations) were utilized to provide functionalities and interface design.
• Designing and modifying DRG Review (Diagnosis Related Group) business application for Confidential .
• The purpose of this application was to improve the efficiency of the medical review process. DRG Review automated all batch processes and provided a modern and user-friendly interface for users.
• The application was completely data-driven. This allowed the application to provide functionality to a user depending on their role as well as define the user’s ability to interact with a review depending upon who they were their role and the status of the review.
• The application was written in VB.NET using SQL Server 2000 running on a Windows 2000 server.

ASP/MS SQL Server Developer

Confidential, Raleigh, NC

Responsibilities:

• Working on the trading floor at Progress Energy providing Information Technology Support for all traders and risk management employees. Maintaining, troubleshooting and modifying all their trading applications according to traders and managers’ needs. Using TOAD as the interface for Oracle database, VBA for MS Access applications, ColdFusion for web based applications, Nucleus, WebICE and VB. Also helping Progress Energy to migrate all their Windows NT 4 servers and workstations to Windows 2000 servers and Windows XP workstations.

ColdFusion/ASP/MS SQL Server Developer

Confidential, Raleigh, NC

Responsibilities:

• I have worked on many different projects including the ones that were designed and developed there before my employment.
• Maintaining and updating ColdFusion applications is one of my main responsibilities at IA. I have developed new web applications as well.
• For example, one of those applications is the admin and client sections of Confidential web site.
• The site is mostly HTML, CSS and JavaScript, but some parts of it are ColdFusion and provide such functionalities as dynamically displaying available employment positions, applying for positions online, and uploading resumes.
• The admin section provided managers with abilities to manipulate data, preview applicants and their resumes, activate/deactivate/delete/add/edit job availability, and manage an email subscription list. (JavaScript is used for forms client side validation and SQL Server for data storage).
• Below I list three major projects that I have designed and developed at Confidential .
• I also have helped with some server hardware and software maintenance and troubleshooting.
• ColdFusion, SQL (communicate with database), MS SQL Server (database, stored procedures), DHTML, CSS, JavaScript (interface and forms validations) were used to provide functionalities and interface design.
• ASP’s, SQL (communicate with database), MS SQL Server (database, stored procedures and triggers), DHTML, CSS, JavaScript (interface and forms validations) were utilized along to provide functionalities and interface design.