19 Jun
SQL Server DBA/Developer
Vacancy expired!
Job Description: The Virginia Economic Development Partnership (VEDP) is seeking an experienced SQL Server DBA / Developer in its Information Technology Division. The primary responsibilities of this position include the design, development, implementation, integrity and support of the enterprise database architecture and programs with some project management. This is a Richmond office-based position.
Design and develop database objects, tables, stored procedures, views and triggers in MS SQL Server.
Create and manage ETLs using MS SQL Server Integration Services (SSIS).
Configure and maintain database servers and processes, monitor system health and performance, ensuring high levels of performance, availability, and security.
- Research and evaluate new products and development needed to support ongoing needs of organization.
- Develops and maintains system documentation, guidelines and presentations.
- Self-motivated, organized, independent, and proactive.
- In-depth knowledge of standard concepts, practices and procedures related to database management and security.
- Experience in proactively monitoring database health, executing maintenance packages, monitoring space and indexing strategy.
- Experience with Microsoft Integration Services (SSIS) and Microsoft Reporting (SSRS).
- Experience with migrating and managing Azure database(s).
- Experience writing technical documentation.
- Data mart or Data warehouse knowledge is a plus.
Manage the deployment of database scripts in development, test and production environments.
Strong communication skills to support all project phases, in particular technical and business requirement discussions.
5+ years in database design, development, optimization and administration of MS SQL Server.
Experience with the installation, configuration and support for MS SQL Server (including SSIS and SSRS) 2012 or newer.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.
Vendor Certification(s) is a plus.
A combination of education, training, and experience equivalent to a Bachelor's degree in information systems or a related field is essential. Candidates with disabilities are encouraged to apply. Applicants must be currently authorized to work in the United States on a full-time basis. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States. All candidates must apply through our website . Application deadline: Open Until Filled.
Vacancy expired!