SSIS / SSRS with DB Developer // Plano, TX // Fulltime

SSIS / SSRS with DB Developer

Database Administrator's role is to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. Production database support of a 24x7 environment and on-call support is required. Perform Design, build, configuration and administration of clusters and standalone Microsoft SQL Server 2008/2012/2014.Install, configure, and maintain SSRS, SSIS, and SSAS instances. Perform database administration tasks such as patching, upgrading, backup/recovery management and capacity planning Creating users and assigning permissions based on the level of database access the user would need Implement monitoring procedures to maximize availability and performance of the database/instances Serve as primary DBA for multiple applications running on SQL Servers. Configure database mirroring, log shipping, always on and SQL replication. Setting up high-availability as part of Disaster Recovery Strategy for the databases Ensures compliance with company standards, policies, and procedures Troubleshooting and performing root cause analysis of problems and recommend solutions to resolve the problems. Performance tuning of SQL databases and Transact-SQL queries Promote system reliability and efficiency by implementing standards and best-practices. Perform code migrations and updates through lower level environment and ultimately into production. Experience working in a 24x7 environment.