Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Sr. SQL DBA

Expired Job

Link Solutions, Inc Washington , DC 20319

Posted 4 months ago

Sr. SQL DBA

Education Bachelor's Degree or equivalent experience

Experience 7+ years

Citizenship Requirement US Citizen

Clearance Required Top Secret

Location Washington, D.C.

Job Responsibilities:

  • Provides O&M system/user support to include regular data updates/loads, requirements gathering, software development, system testing, and release validation

  • Provide as needed back-end software development support for other HR applications

  • Setup and manage server infrastructure of TDE enabled SQL Server 2014/2016 R2 databases and SSRS in various production and non-production environments.

  • Manage operations for SQL Server instances, databases and Web servers.

  • Responsible for creating multiple SQL Server environments (such as Training, Demo, CPY, UAT etc.)

  • Migrate numerous SQL 2008/2012 databases to SQL 2014/2016.

  • Demonstrate strong technical troubleshooting skills in Microsoft Windows server operating system.

  • Patch all SQL servers with latest patches, hot-fixes, service packs etc. during regularly scheduled software release and infrastructure release nights and ensure SQL servers are compliant with Agency security configurations standards.

  • Monitor all SQL Servers with the following system monitoring tools - NetIQ and Spotlight.

  • Provide database support to application developers during application installations and upgrades in addition to general troubleshooting.

  • Develop and manage backup strategies in all environments.

  • Understand and execute all phases of the standard Software Development Life Cycle including technical requirements analysis, design, development, testing, implementation, training and system support.

  • Assist other technical teams to recognize, diagnose, and resolve complex problems or potential conflicts between technologies and platforms within the HR IT environment

  • Systems design, performance tuning, administration, maintenance, and support of SQL and BizTalk physical and virtual servers located locally and remote in a 24/7 enterprise production environment

  • Assist application developers on applications that use the databases to ingest and retrieve data

  • Must be able to work the early and late shifts (7AM 3:30PM & 9:30AM 6PM). Must be available to work one Friday evening a month and one Sat. every 2 months to support production issues, maintenance, migrations, backups, etc.

Qualifications:

  • Strong SQL administration experience required. Extensive SQL Server 2014/2016 exp. in a large scale production environment.

  • Experience with BizTalk server administration, IIS 7.5/8.x

  • Strong technical troubleshooting skills in Microsoft Windows server operating system 2012/2016 R2

  • Experience with system monitoring tools (NetIQ & Spotlight)

  • Experience with Linux and/or similar Unix-based servers

  • 7+ years Microsoft Windows administration, server maintenance and system integration

  • 4+ years' experience administering and troubleshooting Microsoft IIS web server

  • Experience with NetIQ monitoring tool in a large scale production environment

  • Familiarity with Oracle administration tasks including installation, configuration, and backups

  • SQL Server Certification a plus

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr SQL Server DBA

Allstaff Solutions

Posted 2 weeks ago

VIEW JOBS 10/30/2018 12:00:00 AM 2019-01-28T00:00 <p><strong>Summary</strong></p><p>AllStaff Solutions is an established IT and Healthcare Services firm and we love what we do! Our team strives for success and it makes our day when we are able to help talented individuals find their career&rsquo;s next move and our clients find qualified talent. If you are interested in joining the AllStaff Team, please apply or submit your resume for review today!</p><p><strong>Job Title&nbsp;</strong>- Sr. SQL Server DBA<br /></p><p><strong>Duties &amp;Responsibilities</strong></p><ul><li>Ability to obtain a PUBLIC TRUST</li><li>12 + years relevant work experience as a Windows systems administrator with an IT equipment vendor, service provider, or a data center</li><li>Document all platform service processes and procedures and maintain the artifacts in a document repository;</li><li>Perform systems operation support, including server system administration, general troubleshooting, and troubleshooting of complex engineering issues for hardware, software, and network components;</li><li>Participate in disaster recovery (DR) planning and execution in support of customer requirements;</li><li>Support data center consolidation efforts;</li><li>Provide expertise and assistance in migrations to managed service(s); and</li><li>Design, and test application upgrades within specified timeframes.</li><li>Manage and maintain Windows and SQL Server databases in the customer data centers; work directly with customers as required to ensure their needs are met</li><li>Work in a rapid paced environment and work independently</li><li>Maintain the smooth operation including coordination with other administrators, customers engineers</li><li>Set up administrator and service accounts, tune system performance, install system wide software</li><li>Interact with users and evaluate vendor products</li><li>Evaluate hardware and software, with the goal of improving and increasingly automating operations</li><li>Develop and monitor policies and standards for allocation related to the use of computing resources</li><li>Create, maintain, and implement detailed documentation and maintain standard operating procedures</li><li>Apply security settings and other commercial security best practices</li><li>Provide support on business hours schedule; also responsible for on-call, extended hour, and weekend support as required by mission or emergency situations.</li></ul><p><strong>Requirements</strong></p><ul><li>Bachelor's degree in a relevant technical discipline and 12 years of overall related experience with a Windows server environment; additional related years of experience is accepted in lieu of a degree</li><li>The selected individual must be able to investigate complex database issues and provide solutions to technical leadership.</li><li>He/she must have the ability to effectively interface with database team members, software developers, customers, and senior-level management to influence program-wide decisions, efficiently investigate complex database issues, and provide solutions to technical leadership. </li><li>He/she will be expected to review existing data models and provide both high-level and detailed recommendations for improvement to the data architecture. </li><li>Solutions developed to support the customer's needs will be written using SQL, PL/SQL, and scripting languages. </li><li>Other tasks may include data conversion, and other database-centric process improvement initiatives.</li><li>Applies best practice for tuning SQL databases to improve overall system performance.</li><li>Proficiency with Advance Microsoft SQL structures SSIS, SSAS SQL Clustering</li><li>Researches interfaces to identify and code required updates to support integration.</li><li>Ensures software releases are fully supported and gains approvals before implementing new changes into the production environment.</li><li>Creates and maintains all SQL databases required for development, testing, and production usage.</li><li>Performs planning and assists application developers and System administrators, to ensure that any new SQL products or release upgrade takes place with minimal impact.</li><li>Administers all SQL database objects, including tables, clusters, indexes, views, sequences, packages procedures.</li><li>Troubleshoots all problems regarding SQL databases, applications development tools.</li><li>Creates new SQL databases as required, enforces and maintains database constraints to ensure of the SQL database PowerShell Scripting experience</li><li>Completing registry backups and modifications</li><li>Group Policy Management (GPO) and application of Local Security Policies</li><li>Use of Windows Task Scheduler</li><li>Application of security settings/STIGs and other commercial security best practices</li><li>System (hardware) and application (software) installation and configuration</li><li>System monitoring using installed tools as well as external tools</li><li>Experience with configuration, troubleshooting and maintaining virtual and cloud environments</li><li>Excellent written and verbal communications skills</li></ul><p><strong>Other Details</strong></p><ul><li>MCSE certification</li><li>Microsoft SQL Server 2008</li><li>ITIL training and/or certification</li><li>Past experience with the Department of Justice</li><li>DOJ or DOD Active Clearance</li><li>Customer interface experience</li><li>Managing Active Directory/ADFS and DFS</li><li>Network knowledge and experience</li><li>Working knowledge of NetApp and other storage devices</li><li>Exposure to SQL and Oracle and database concepts and installations</li><li>ITSM knowledge and experience, particularly with Remedy</li><li>This position requires that a security investigation completed by the DOJ to permit access to customer-sensitive but unclassified information.</li><li>Microsoft Windows Server 2008 and newer</li><li>Microsoft System Center Configuration Manager</li><li>(SCCM) 2012 and newer</li><li>Microsoft System Center Operations Manager (SCOM) 2012 R2 and newer</li><li>Microsoft Operations Management Suite (OMS)</li><li>Microsoft Azure Backup</li><li>Symantec End-Point Protection 14 and newer</li><li>Citrix XenApp 7.9 and newer</li><li>Veritas NetBackup 8.0 and newer</li><li>Veritas Enterprise Vault 12 and newer</li><li>NetIQ Directory and Resource Administrator (DRA) 9.1 and newer</li><li>NetIQ Self Service Password Reset (SSPR) 4.3 and newer</li><li>Meta-Directory Services (MDS)</li></ul><p><strong>What we Offer</strong><br /></p><p /><ul><li>Competitive Compensation &amp; Benefits package including extensive Health Care Plan and 401K.</li><li>10 holidays and 2 weeks of PTO.</li></ul><p /><p><strong>How to Apply</strong><br /></p><p>Please submit your resume below for this opportunity and to view other positions available, visit our career&rsquo;s page at https://jobs.crelate.com/portal/allstafftechnicalsolutions/job/bjw21z05mca-213607</p><p>AllStaff Solutions is an equal employment (EEO) employer and terms of employment are without regard to race, color, religion, sex, national origin, age, disability or genetics. AllStaff Solutions complies with applicable state and local laws governing nondiscrimination in employment. This policy applies to all terms and conditions of employment.</p><p>&nbsp;</p> Allstaff Solutions Washington DC

Sr. SQL DBA

Expired Job

Link Solutions, Inc