SQL Server DBA (GC And USC Only)
AAA Global Technologies LLC
Richmond , VA 23173
Posted 2 months ago
Greetings from AAA Global Technologies
Wehave requirement with one of our direct client. If you are interested,kindly revert me back with Updated Resume
Title/Role : SQL Server DBA
Worksite Address : Richmond, VA
Position type : Contract to hire
JOB DUTIES AND RESPONSIBILITIES:
Seeking a SQL Svr Database Administrator to work within the database team to administer databases and provide database or software changes to all environments as appropriate. The DBA will also work within the database team to apply upgrades and fixes to software and servers and migrate to new versions as appropriate. The day-to-day tasks may include analysis, design, and creation of complex stored procedures.
Additionally, the Database Administrator will be responsible for creating SSRS reports, and SSIS Packages. Other day-to-day tasks can include performance tuning of SQL queries; database optimization, proactively monitoring systems for optimum performance, tuning, and capacity constraints; production support tasks for data changes and ad-hoc reports as necessary. The Database Administrator will work with the DBA team to administer databases and provides database changes at all levels/across all environments; apply upgrades, fixes, and migration to new versions as appropriate; provide data assurance by documenting and implementing data security requirements; and perform and plan disaster recovery (backups and testing of backups) strategies.
Must pass criminal background check.Requirements:
Graduation from a four-year higher education institution, with a BA or BS degree. The education major should be in computer science, information systems, or a related field unless the candidate has equivalent in training and/or experience.
Significant knowledge, ability, and experience in developing SSRS reports, SSIS Packages and stored procedures. Significant knowledge and experience of SQLServer versions 2008 to 2014.
Significant knowledge of many of the following:
T-SQL; performance optimization methods; database security; SQL Table Partitioning; Stored Procedures; Triggers; SSIS/DTS/EDI/ETL; and Windows 2008 to 20012R2 server Administration.
Experience working with SQL Server using Java/J2EE connection pooling is a plus. Significant experience working with Business Systems Analysts, end-users, and Project Managers and other technical staff on small technical projects.
MCSA: Microsoft Certified Solutions Associate;
MCSE: Microsoft Certified Solutions Expert;
Required / Desired
Experience working as a SQL Server DBA using any versions from 2008 to current
Developing and publishing reports using SQL Server Reporting Services (SSRS)
Developing and publishing packages using SQL Server Integration Services (SSIS)
Working within a Software Development Life Cycle (SDLC)
Working with an Information Technology Infrastructure Library (ITIL) based support system
Nice to have
Experience with either Microsoft SQL Server 2016 or Microsoft SQL Server 2017
Nice to have
TSQL Development on things such as Stored Procedures, Views, Functions, etc.
Nice to have
7000 Peachtree Dunwoody Rd Bldg. 11, Suite 301
Atlanta, GA 30328
SQL server DBA,SSRS,SSIS, SDLC, ITIL, MS SQL Server 2016 or MS SQL Server 2017,T- SQL, ETL/Data migration., Auditing