Sr. SQL Server Database Administrator

Sr. SQL Serever Database Administrator
This is an individual contributor role responsible for solving complex problems and taking a broad perspective to identify innovative solutions. This role serves as a technical/functional specialist and works independently with guidance only in the most complex situations.

The Sr. Systems Administrator will join Global Physical Security Systems team, which is responsible for the design, maintenance and management of the underlying server infrastructure supporting the Global Access Control, Video Surveillance, Visitor Management and other infrastructure Monitoring solutions used to securely manage physical locations across the world. The Global Physical Security Systems team is responsible for a wide range of technology solutions used to monitor & manage  global physical footprint. Much of this technology is commercial off the shelf (COTS) solutions provided by industry leading vendors e.g. Software House CCure 9000, DvTel Video Surveillance, Quantum Secure, etc.
Job Functions:
•    Provide primary system and database administrative support for our Physical Security Systems e.g. Access Control and Video Surveillance systems. This role will primarily responsible for the ongoing maintenance and operations of all systems along with performing installation, configuration, and testing of all aspects of the Physical Security Systems. This includes upgrades, managing production defects, working with our business partners, vendors, development teams, and supporting applications.
•    Ensure that all documentation related to the system and database administration is kept current and up to date for other system and database administration as well as other team members; Track issues via incident and problem resolutions; Compose clear documentation and reports, assess operational impacts, provide estimates, ensure operational acceptance, develop and improve support processes and solutions and be involved in projects to supply applications with solutions to their issues;  Enhance the technical maturity level of our systems by eliminating manual processes through automation
•    Maintaining and expanding the existing Backup strategy and infrastructure; Technical working knowledge of Disaster Recovery concepts and best practices, including experience with Big Data volumes; Working directly with colleagues to maintain and evolve the Disaster Recovery Planning, Testing and Response for the Enterprise; Leverage existing Backup Infrastructure for Operational efficiency, including data staging, recovery and hardware migration
•    Candidate must be able to effectively communicate with customers, system administrators, team members, and management and use sound judgment when considering enterprise impacts of technical decisions. Excellent writing skills with the ability to document applications.

Qualifications

Experience
•    Bachelor’s degree or equivalent experience required.
•    System Administration and Database Certifications required. Special consideration for Red Hat Certifications.
•    Special consideration for experience with Software House CCure 9000 and DvTel Video Surveillance systems.
•    Experience working in 24*7 environments will be key to this role.
•    Experience programming in technologies like Visual Studio .Net, C#, ASP.Net & SQL
•    Experience working with SQL Server 2005/2008/2012 Database, SSIS and SSRS
•    Thorough knowledge of Windows 2008/2012 & IIS 7/8.
•    7+ years in a successful development environment regularly releasing well-tested solutions with complex integrations to meet application and service objectives.
•    Working knowledge and experience with scripting & UI languages such as PERL, PYTHON, PHP, etc.
•    Ability to work on multiple, simultaneous initiatives of which he/she will apply their applicable business, technical and system functionality background.
•    The Physical Security Systems team prides itself in keeping Physical Security systems up and secure, catering to the 24*7 needs of the business.

Candidate must have
•    7+ years of script development including Windows batch file, WMI, VBScript, and PowerShell
•    2+ years of experience with SCCM 2012.
•    Capability to create system integrations utilizing web services, APIs, Java, C, etc. extremely beneficial.

Additional Information

As part of the team:
•    You will be responsible for developing and supporting critical system solutions to ensure the physical security of our locations by performing proactive maintenance activities, engage in automation activities, root cause analysis, and remediation.
•    The role requires working knowledge of production support processes such as incident/change/problem management, remediation packaging, and package deployment and reporting.
•    The role will also demand the ability to write and maintain scripts to remediate vulnerabilities during pre and post production implementations, and working with application teams to perform post-remediation validation.