Role: MS SQL Server DBA Location: Montgomery, AL Duration: 6+ monthsJob Description:
- Manages and maintains all production and non-production databases.
- Responsible for standards and design of physical data storage, maintenance, access and security administration.
- Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Additionally, this position will assist with web administration for mission critical web servers with a focus on web applications' deployment, connectivity and maintenance. This will include expert escalation for troubleshooting production issues, assists in development lifecycle, capacity management and strategy, operational standards and procedures, stabilization and optimization, performance tuning and monitoring, standards identification and compliance, continuous improvement, and security enhancement.
Experience Required:
- 5+ years of experience in working as MS SQL Server database administrator and database internals, with strong focus in SQL Server 2016, 2019, and 2022.
- Expereince in SQL Server database performance tuning along with good understanding of indexing, execution plans, DMV, database storage, database problem identification, problem diagnosis and resolution.
- Expereince in writing scripts or using leading tools to monitor, perform backup & recovery, and maintenance automation; hands on experience in on-prem to cloud migration; hands on experience in creating and troubleshooting SSIS packages.
- Experience in performing code. .
Education Required:
- Bachelor's Degree or higher in Computer Science, Information Systems, or related disciplines.
Education Preferred:
- Microsoft Certification in SQL Server Database Administration.
AgreeYa Solutions is a leading global provider of software, solutions and services to small, medium and Fortune 100 organizations. Founded in 1999 and headquartered in Folsom, CA, AgreeYa has over 2,500 professionals helping clients across U.S, India, Mexico, and Singapore. Leveraging a technology-enabled, consultative approach and diverse talent, AgreeYa offers modern workplace, smart analytics, intelligent automation, AI/ML, cloud transformation, mobility and talent management solutions to deliver digital transformation to its clients. AgreeYa has received considerable recognition including certifications like Microsoft Solutions Partner and Cloud Solutions Provider, AICPA SOC 2 Type 2, SEI CMMI and ISO 9001:2015; and awards including 'Dream Company to Work For' and 'Best Employer Brand'. Follow us on LinkedIn , Facebook , and Twitter .