TECHNOLOGIES:

PROFESSIONAL EXPERIENCE:

Sr. SQL Server DBA/Developer

• Senior DBA/Developer responsible for development and administration of production, test, and development SQL 2005 2008R2 Servers in hosted virtual environment
• Participates in all phases of the software development and maintenance life cycle including code reviews and requirements gathering
• Wrote SQL Server ETL application for migration of warehouse inventory and setup data from Oracle to SQL Server.
• Lead Developer on several software build projects. Responsible for managing release through all phases including testing and promotion.
• Rotating 24x7 On-Call support of core application and database.
• Writes complex T-SQL stored procedures, triggers, functions, and complex queries for extraction, evaluation, scrubbing, transformation, reporting, and analysis of food industry warehouse data from Oracle to SQL Server.
• Maintain and monitor SQL Server systems using email alerts and key performance indicators.
• Developed and configured SSRS application for tracking SQL performance and data statistics, KPIs and progress towards company goals.

Sr. 2 SQL Server DBA/Developer

• Senior DBA/Developer responsible for all corporate SQL Servers local and remote .
• Developed complex SSIS packages and ETL processes to perform remote data collection from many different, sources, platforms and data types. Evaluate data for consistency, accuracy, and completeness to eliminate duplicate or missing data and ensure reliability.
• Functioned as technical lead in planning, modeling, design and implementation of corporate SQL environment, including hardware requirements, configurations and security.
• Wrote complex SQL Server 2005 and SQL 2008 stored procedures, triggers, functions, and complex queries for extraction, evaluation, scrubbing, transformation, reporting, and analysis of financial data from various internal and external sources and formats.
• Assisted in development, implementation, productivity, and documentation of SQL Server components for end-user BI dashboards and status reports, and production reports.
• Built and deployed SQL Server Reporting Services intranet portal. Wrote and deployed SSRS reports to portal based on requirements.
• Planned and implemented best practices for optimal performance, tuning, optimization, troubleshooting, and availability of local and remote SQL Server systems.
• Worked with LAN/WAN and Domain administrators to evaluate and resolve remote connectivity and performance issues and maintain security updates and service packs of servers.
• Provided detailed documentation of physical environment, ERD and data models, logical processes, and methodologies for all SQL Servers as peer-user documentation and ensure business continuity in disaster recovery scenarios.
• Proactively maintained and monitored internal and remote SQL Server systems. Set up email alerts and key performance indicators.
• Assisted web developers and .NET developers in developing, testing and implementing integrated applications by writing complex SQL components and by providing technical support and expertise of all SQL Server components and processes.

IT/SQL Consultant CEO

• Own and operate all aspects of upstart IT consulting firm
• Primary responsibility to perform competent work to the complete satisfaction of existing clients
• Other roles include new client sales. Provide technical specifications of job, and negotiating job contracts that benefit clients.
• Designed SSRS solutions for clients. Provided services to support SSRS deployments including report writing and maintenance.
• Performed installation, configuration, and maintenance of all hardware, software, network, and communication components for computer systems ranging from personal desktops to Client/Server LAN/WAN based networks using Windows Server OS, Exchange Server, Microsoft BackOffice, SQL Server, SharePoint, and SMS.
• Troubleshot, torn apart, and repaired hundreds of PCs and Servers for issues ranging from motherboard replacement, new memory or other cards, incompatible drivers, etc.
• Designed and/or developed, user-friendly customized, relational database applications for small businesses, churches, dentist offices, and other organizations clients using SQL Server 2000, MS Access, and/or Visual Basic. The specific application components vary depending on client needs but most all include customized data entry forms, data analysis queries, and summary reports.
• Developed web sites and web pages for clients. Help identify and setup available hosting packages for clients.
• Installation and optimization of productivity, networking, and communication software and services.

SQL Server Developer-DBA

• Wrote complex SQL Server 2000 and SQL Server 2005 stored procedures, triggers, functions, and complex queries.
• Developed and implemented 'home-grown' applications and solutions to resolve a variety of different needs using SQL Stored Procedures, VB.Net, Active-X, XML XSL, Reporting Services, and .NET Applications for SQL 2000 and Yukon.
• Modified existing SQL code to improve speed and overall performance of the Swingvote application.
• Administered performance, tuning, troubleshooting, and availability of internal SQL Server systems on Windows 2000 2003.
• Responsible for and performed all security updates and service packs for servers and applications in addition developed and improved security controls for SQL Servers including Business Continuity and Security Audits.
• Maintained the integrity and security of development SQL code from Alpha code through release-to-production.
• Performed all aspects of SQL Server code management by following standard Software Development Cycle best practices.
• Maintained and monitored internal SQL Servers. Set up email alerts and key performance indicators.

Senior SQL Server DBA

• - Functioned as Senior SQL Server DBA responsible for maintaining several high availability production SQL Server 7.0/2000/2005 Applications in highly secure distributed LAN and WAN environments.
• - Managed Enterprise operational database infrastructure for all internal database systems based on SQL Server and Analysis Services.
• - Worked extensively with DTS and SSIS to extract, transform, and load data from various heterogeneous sources including HTML, XML, Oracle, Lotus Domino, SQL, AS400, Flat Files, Access, Excel, etc.
• - Responsible for the development, implementation, ETL, reporting, and maintenance of SQL Server 2000/2005 BI , Data Warehouse and Reporting Solution using SSAS, SSIS, and OLAP reporting tools such as ProClarity, Crystal Reports and SSRS. This solution was used for overall business analysis, upper management decision making, and executive financial reporting. Assisted in writing MDX for SSAS.
• - Wrote complex stored procedures, complex queries fact tables, data marts, cubes, dimensions, etc against SQL Server and Analysis Services to provide data to meet user BI and Reporting needs.
• - Developed and maintained financial data portal accessible via Intranet using SharePoint 2003 technologies and IIS.
• - Responsible for managing the technical performance and assigning workload of two junior level SQL Server DBAs.
• - Modeled, Architected, Designed, and Implemented SQL Servers and databases of various sizes and specifications to meet performance and design requirements.
• - Developed and implemented applications and solutions to resolve a variety of different needs using SQL Server Stored Procedures, VB.Net, Active-X, XML XSL, Reporting Services, and .NET Applications for SQL 2000/2005 Data Transformations and MySQL from native data various systems and formats including Lotus Notes, Oracle, Linux, and AS400. - Administered all aspects of performance, tuning, troubleshooting, and availability of both clustered and un-clustered SQL Server 2000/2005 environments running on Windows 2000, Windows 2003, and Windows NT.
• - Responsible for and performed all security updates and service packs for servers and applications in addition developed and improved security controls for SQL Servers including Business Continuity and Security Audits.
• - Responsible for compliance with Sarbanes-Oxley audit requirements for all SQL Server related systems and data.
• - Responsible for data integrity and reliability for Great Plains Accounting System and Human Resource Management System.

Senior SQL Server DBA

• - Functions as Senior DBA with primary responsibility for company's 24x7 production database systems supporting .COM Internet applications.
• - Primary focus on SQL Server Availability and Reliability SQL Instance and Database Security Backup, Recovery Contingency Planning and Implementation Server Database Performance Tuning and Optimizations Index Creation and Tuning Query Design Optimization Performance Monitoring and SQL Development.
• - Writes Stored Procedures, Triggers, User Defined Functions, SQL Scripts, VB/Active X Scripts Creates and Implements Data Transformation DTS Packages and Jobs as part of continued application development and enhancements.
• - Responsible for Windows 2000 Advanced Server /Windows NT 4.0 Server administration of servers running SQL Server instances.
• - Maintains and troubleshoots all SQL Server and Windows 2000/NT issues impacting database servers.
• - Generates ad hoc database reports to support management and staff using Crystal Reports and Microsoft Access.

Senior SQL Server DBA

• - Performs all DBA functions for all Matria's SQL Server 2000 and SQL Server 7.0 databases, including Installations, Upgrades, Service Packs, and Migration to new releases of SQL Server Availability and Reliability Testing SQL Server and Database Security Disk Management and Capacity Planning Backup, Recovery Contingency Planning and Implementation Server Database Performance Tuning and Optimizations Index Creation and Tuning Query Design Optimization, Implementation, Optimization, and Analysis.
• - Responsible for developing, testing, and executing plans to extract data and recordsets from various sources, hardware platforms, data formats, and database applications.
• - Responsible for extraction, loading, scrubbing/transformation, verification, and querying of dissimilar data elements from various sources and formats. Creates homogeneous/heterogeneous linked servers to facilitate seamless data sharing between remote SQL Server and/or Oracle databases.
• - Writes Stored Procedures, Triggers, User Defined Functions, SQL Scripts, VB/Active X Scripts Creates and Implements Data Transformation Packages and Jobs Data Warehousing Implementation, Database Modeling and Implementation for Application Development. Work as a Part of Software/Application development group and data team.
• - Assists Oracle DBA in administering and maintaining Oracle 8.0.6.0 and Oracle 8.1.7 databases. Serves as primary backup for Oracle DBA.
• - Develops and Maintains Technical Specifications and Documentation for all SQL Server Installations
• - Develops and Maintains Matria's Emergency/Contingency Plans, Policies, and Procedures for all SQL Servers
• - Develops requirements documentation for SQL Servers to be deployed with applications.
• - Performs load/stress testing of servers/databases/tables/indexes for application development team.
• - Develops/Troubleshoots/Modifies End User Database Applications Visual Basic, Access 2000/97, Proprietary .

CIO, IT Director, Senior DBA, Systems Engineer

• - Performs as Senior Database Administrator with full responsibility over all SQL Server 7.0/2000 and Oracle 8i databases. Responsible for all operational/production and development database issues including: Creation, Performance, Tuning, Maintenance, Troubleshooting, Backup/Recovery, Sizing, Replication, Scalability, Modeling, Migration, and Security.
• - Writes and implements SQL Server and Oracle stored procedures, triggers, functions, plans, DTS scripts etc. using tSQL, PL/SQL, VB/Java script. Develops database applications for new and existing tasks to meet user needs. Provides technical assistance to and collaborates with staff and program managers to ensure system usability and compatibility for all ongoing database development. Coordinates, directs, and oversees development of outsourced databases and database applications.
• - Responsible for planning, development, testing, migration, and implementation of the Integrated Preservation Software database application from DOS based dBase III to SQL Server 7.0.
• - Responsible for extraction, loading, scrubbing/transformation, verification, and querying of data from various sources and formats.
• - Serves as Project Manager/Director for all DHR IT initiatives. Designs, develops, and directs complex new projects or completes extensive modifications or enhancements to existing projects and services by providing direction and leadership to staff, partners, and contractors.
• - Functions as Agency Information Officer and the Agency Information Security Officer. Serves as agency liaison to the Commonwealth of Virginia Secretary of Technology. Serves on the Virginia Council of Technology Services Enterprise Architecture Workgroup and the Organizational Workgroup to develop statewide IT policies and guidelines.
• - Directs, plans, designs, manages, and maintains all aspects of the DHR IT/Network System and Database Systems. Ensures agency business technology and systems are adequate for 24/7 agency business operations and compatible with upcoming B2B transactions and emerging technologies. Responsible for the development, performance, security, procurement, and maintenance of all IT system hardware and software.
• - Provides expert technical support services to DHR local and remote users including hardware/software installation, maintenance, network administration, database administration, software development, and problem assistance. Conducts assessment of satisfaction with support provided. Assess user training needs and makes administrative arrangements for training and/or conducts training classes for agency users.
• - Supervise employees to ensure quality results from assigned tasks.