I am a SQL Server expert with over 10 years of experience. I am offering SQL Server development, administration (DBA) and reporting services on short, long-term or on-going project basis. My terms are flexible and my goal is to help you address your needs faster without having to commit to a full-time resource or a long-term contract. As an independent contractor, my rates are affordable as I have minimal overhead. I stand behind the quality of my work. I have expertise and experience and can help you in the following areas: Here is additional experience • Maintains, migrates, and monitors SQL Server 2014/2012/2008/2005/2008 Clustered (active/passive) environments with SAN (EMC Clarion) storage with over 300 databases (biggest DB is 1.2 TB) and 600 million transactions per day • Ensures the security of the company’s data sources by developing and enforcing data security procedures including HIPAA • Installs, configures, troubleshoots, and maintains database components including SQL Server Reporting Services (SSRS) and Integration Services (SSIS) • Designs and implements data warehouse following Ralph Kimball’s dimensional methodology • Designs, implements, and maintains transactional and snapshot replication topologies and database mirroring to distribute data across systems • Achieves high and sustained database performance through continuous monitoring and performance tuning by indexing, disk configuration, and query optimization, among other methods • Implements database maintenance plans that include backup, recovery, and optimizations strategies • Utilizes ETL(SSIS) process to load a data warehouse from OLTP systems • Ensures data integrity by implementing constraints and developing T-SQL coding standards • Responsible for creating, scripting, migrating, and maintaining database objects including tables, stored procedures, indexes, logins, roles, views, triggers, SSRS reports and SSIS packages • Proactively monitors and responds to database alerts for disk space, hardware failure/warning, excessive blocking, deadlocks, process/job failure, and runaway queries, among others • Manages data volumes by archiving and purging old data to free up resources for active data • Collaborates with multiple departments to design and maintain systems and make business decisions critical to the company’s smooth and profitable operation • Performs talent selection and acquisition as well as addressing personnel issues • Responsible for database change control process to ensure coordinated testing and deployment of database software • Ensures continuity of business by documenting and implementing backup and recovery strategies