14 days old
2018-04-112018-05-09

Microsoft SQL Server Developer/DBA

Washington, DC 20433
  • Job Code
    601460

Description:


The Open Data suite of products (Databank, Open data APIs, data management tools) are being enhanced to build a more usable, functional, and robust open data management, publishing and browsing system. These activities will leverage the existing work done on the open data platform. Improvements will be done to Data Management tools, Data Collection System (DCS), to address the challenges raised by the open data initiative by speeding the collection process and automating the data flow. Partially implemented in automating the publish process to dissemination systems, databank and Open Data APIs, for the existing datasets successfully. Current environment is in SQL 2012. Following are the tasks to be performed by the resource.


- Primarily works on SQL development project.


- Migrating SQL 2012 to SQL 2016 or latest environment, if needed.


- Ensuring all the features and performance in new environment


- Implementing planned new features in DCS and Open Data APIs


Strong skills required:


- Experience in latest Microsoft SQL server development skills.


- Strong knowledge and hands on expertise in SQL server stored procedures, functions, triggers, indexes, jobs and performance tuning.


- Expertise on SQL Server Analysis Services, cubes and MDX query operations.


- Hands on SQL Server Integration Services experience and CLR implementations


- Strong communication skills


Optional skills required:


- Microsoft .NET language knowledge


- Documentation knowledge.


Position Overview:


This job position is for MS SQL Server database administrator (MS SQL DBA) performing physical infrastructure activities in the Database and Reporting (WR) unit of ITS VPU.


The candidate will be responsible for install, configure, patch and maintain SQL Server software on Windows environment for Standalone and High Availability clusters, Infrastructure setup, administration, maintenance, performance management, Assisting Application team in detecting performance problems, Providing backup and restore functionality, Implementing database failover technologies using High Availability clusters, Database mirroring, Always ON features and following Client database security standard implementation process for SQL Server database environment.


Essential Job Functions:


- Install, configure and maintain Microsoft SQL Server2008 R2 and SQL Server 2012 in Windows 2008 and Windows 2012 server


- Tune database configuration and parameters for optimal system performance.


- Ensure proper setting of system memory and system parameters in consultation with windows administrators


- Strong production experience in managing MS SQL Server clustered environment for mission critical systems


- Create and maintain application databases with optimal data file and log file sizes


- Assist developers in detecting performance problems including analysis of SQL, Transact-SQL,OLEDB and ODBC connections.


- Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments.


- Provide backup and restore functions for MS SQL Server databases


- Develop and maintain DBA scripts supporting the database function using Windows Power Shell scripts


- Periodically refresh development and test databases using copy of production system


- Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary


- Manage the setup of MS SQL Server databases at Business Continuity site


- Configure and manage the database systems as per security guidelines and industry best practices such as SOX, HIPAA, and PCI


- Follow ITIL process in the system administration and need to be familiar with ISO 20000 and ISO 24001 processes


- Maintain highly available SQL Server databases using SQL Database Mirroring and SQL Always On Technology


- Maintain highly secure SQL Server databases using SQL Transparent Data Encryption, SQL Line Encryption, and enhanced SQL Server auditing features


Educational Qualifications and Experience:


- Education: Bachelor's degree in Computer Science, IT, or STEM related fields


- Role Specific Experience: 5+ years of relevant experience as a DBA in MS SQL Server systems on Windows 2003 clustered platform


- Strong production experience in managing MS SQL Server clustered environment for mission critical systems


- Advanced experience in backup and recovery in SQL Server 2008 R2 and SQL Server 2012


Certification Requirements:


- MS SQL Server DBA 2008 certification is a plus


Required Skills/Abilities:


- Proficiency in installation and maintenance of SQL Server clusters for high availability


- Advanced knowledge of Windows Server 2008 and Window Server 2012 operating system environments


- Advanced understanding of underlying windows cluster technology


Desired Skills/Abilities (not required but a plus):


- SQL Server deployment in SharePoint environment


- Cloud deployment experience in Microsoft Azure

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Microsoft SQL Server Developer/DBA

Randstad Technologies
Washington, DC 20433

Share this job

Microsoft SQL Server Developer/DBA

Randstad Technologies
Washington, DC
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast