Provide technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies. Key Duties and Responsibilities .- Assisting with administering, maintaining, developing and recommending policies and procedures for ensuring the performance, availability, security and integrity of the company’s databases and systems. .- Store procedures, triggers, and reports creation. .- Responsible for maintaining and improving the company’s reporting system: optimizing and creating reports, troubleshooting and monitoring. .- Reactively monitoring production databases and sp execution for performance. Troubleshoot locking conflicts/blocking and resource utilization. .- Investigate database performance issues, database capacity issues and other database issues .- Knowledge of SQL BI tolls: SSRS, SSIS, SSAS. .-Assist development team with database and query design. .- Ensuring availability and integrity all database [login to view URL] skills Experience: .- of Transact-SQL experience in a transaction processing environment .- on performance tuning on MS SQL Server (with data integrity, data retention) .- on RAID & SAN configuration and management, i/o monitoring, etc. .- in database performance troubleshooting and optimization .- Knowledge of SQL Reporting Services and SQL Integration Services .- Knowledge of SQL Service Broker, SQL clustering, SQL replication, hardwarereplication, and/or disaster recovery implementations strongly desired .- Solid understanding of RDBMS concepts