Sarian Solutions Inc.
Trusted Partner for your all IT Needs.
Job DescriptionJob Title: SSIS / SSRS with DB Developer
Location: Plano, TX
Duration: Full-Time
Job Description:
- Minimum 5+ years of experience
- SQL Server 2008/2012/2014/2016 standalone and clusters
- SQL Server Reporting Services
- SQL Server Integration Service
- Analysis Services
- Proficient in Always on/Mirroring/Log Shipping
- Foglight
- SQL Litespeed
· 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.
Additional InformationLooking forward to hear & work with you soon.
Thanks & Regards
Mohammed Riyaz
Sarian Solutions, Inc.
an IT solutions company
Work: 732-790-2266 x 201|Fax: 732-790-0944
E: Riyaz(AT)sariansolutions.com | G: riyaz.ross(AT)gmail.com
W: www.sarianinc.com
Skills Required
- Minimum 5+ years of experience
- Microsoft SQL Server 2008/2012/2014/2016 (standalone and clusters)
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- SQL Server Analysis Services (SSAS)
- Always On, database mirroring, and log shipping configuration
- SQL replication configuration and administration
- Foglight monitoring experience
- SQL LiteSpeed (Litespeed) experience
- Design, install, monitor, maintain, and performance tune production databases
- Experience supporting production 24x7 environments and on-call support
- Patching, upgrading, backup/recovery management and capacity planning
- Create users and assign database permissions
- Implement monitoring procedures to maximize availability and performance
- Troubleshooting, root cause analysis, and recommending solutions
- Performance tuning of SQL databases and Transact-SQL queries
- Perform code migrations and updates through lower-level environments into production
What We Do
Sarian Solutions Inc. is a global information technology and business solutions provider specializing in IT consulting and staffing services. The company delivers comprehensive business solutions using digital technologies including cloud, mobile, security, and data analytics. As a trusted partner, they empower businesses of all sizes to achieve digital transformation through custom software development, strategic guidance, and global talent acquisition.
.png){kind=avatar}
