Resolvit IT & Management Consulting (Resolvit) is looking for a SQL Server DBA to work as full-time Resolvit employee on a federal contract in Washington, DC.
The essential duties include:
Architect, design, install, configure, optimize and manage complex enterprise-wide SQL Server 2005 and 2012 instances, running on Windows Server 2003 and 2008 R2.
Transaction log management as well as Backup and recovery operations
Heavy emphasis on designing and building the SQL Server architecture for SharePoint 2010.
Very heavy emphasis on complex Windows and SQL cluster builds with 3 or more nodes, with SAN data being replicated to a secondary data center with another 3 or more node cluster.
SQL Server DBA for over 100 Instances of Microsoft SQL Server 2005 and 2012.
Develop and implement complex T-SQL, VBScript and PowerShell scripts for administration tasks.
Upgrade DTS packages to SSIS, and develop new SSIS packages for ETL.
Monitor and optimize index fragmentation using scripts from Ola Hallengren.
Perform regular maintenance including index optimization, consistency checks, and data file and transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail; and enterprise monitoring using SCOM.
Member of a distributed team where excellent communication and documentation skills are a must.
Author and maintain all SQL Server documentation including DBA manuals for most every server including design, installation and configuration, as well as detailed work logs.
Ensure high-availability and data security by implementing Windows and SQL Server Failover Clustering and SQL Server 2012 AlwaysOn Availability Groups, rigorous backup and recovery plans, SAN mirroring to disaster recovery sites, and implementation of Department of Homeland Security SQL Server hardening guidelines and auditing.
Carry a Blackberry and provide 24x7 troubleshooting and Tier-3 support SQL Server.
Responsible for many related technologies including installing Windows Server on both physical and virtual machines in VMware, implementing iSCSI as needed, allocating EMC/Clariion SAN LUNs and mount points, creating service accounts and adjusting
GPOs in Active Directory, configuring networking and firewall rules, and much more.
Topology and capacity planning including number of Windows and SQL Server cluster nodes and SQL server instances, CPU and RAM speed and quantity, local disk configuration.
In-depth SAN optimization including LUN, mount-point, RAID and spindle configurations, queue depth, and load-balancing algorithms.
Build, deploy and manage SQL Server Management Data Warehouse and Utility Control Point servers.
Routinely solve critical production problems, and perform point-in-time database recoveries.
Apply SQL Server Service Packs to the current patch level, and Cumulative Updates as required to address specific issues.
Troubleshoot performance issues and other problems using SQL Server profiler, SQL Server Performance Dashboard Reports, Activity Monitor, PAL tool and Perfmon.
Encrypt SQL Server databases using Transparent Data Encryption.
Maintain consistent development, testing, staging, production and disaster recovery environments, both on physical machines and VMware virtual machines in three secure data centers.
Upgrade SQL Server 2005 databases used by SharePoint 2007, to SQL Server 2012 databases used by SharePoint 2010.
The ideal candidate will possess the following qualifications:
Very organized, with attention to detail.
SQL Server Administration 2007 and 2011 (including clustering experience)
Experience with SQL Server 2012 AlwaysOn Availability Groups a plus.
Familiarity with SQL Server Remote Blob Storage and Metalogix StoragePoint.
Familiarity with SCRUM process.
Oracle RAC/ASM installation and administration 11gR2
Database tuning for bulk I/O tuning.
SQL*Loader – handling Gigabytes of data loads
Familiarity with ETL tools
Will be a US Citizen with a DHS Public Trust, Active Secret Clearance, or Active TS Clearance
We're a progressive management and IT consulting firm that helps clients' businesses grow with the power of our people—functional and technical experts who bridge the gap between IT and the business that it supports.
Our projects focus on software development and infrastructure support in the vertical markets of: telecommunications, healthcare and biotechnology, manufacturing and distribution, finance, media, and government. Our project managers, programmers, designers, analysts, and engineers support Fortune 1000 clients.
We've grown 121% over the last two years. How? We hire the best in their fields—results-focused professionals with skills that are re-deployable from one engagement to the next. Our employees receive excellent benefits to include Health, Dental, Vision, 401K, Tuition Reimbursement and more.
At Resolvit, you'll be one of the people growing our business. We'd like to make you part of our success. Contact us to discuss your future.
Click here to apply online
Resolvit, LLC - 2 years ago
copy to clipboard
Resolvit, LLC is dedicated to providing technology and business consulting solutions to clients in the New York City, Washington, DC,...