What are the responsibilities and job description for the SQL Server DBA ( Must be Local to Los Angeles) position at Genesis Global Recruiting Inc?
Job Details
We seek to hire an experienced SQL Server DBA with 10 years of experience. Must have en or more (10 ) years of experience performing SQL Server installations, configurations, management and monitoring, and system administration tasks at the level of a SQL Server DBA.
NO C2C. This is a direct hire position on a W2
escription | A Technical Architect will serve as the manager of complex technology implementations, with an eye toward constant reengineering and refactoring to ensure the simplest and most elegant system possible to accomplish the desired need; understand how to maximize leverage of the open source community to deploy systems on Infrastructure as a Service (IaaS) providers; be comfortable sharing knowledge across a multi-disciplinary team and working within various methodologies; and be a full partner in the determination of vision, objectives, and success criteria. The Technical Architect will architect the overall system by using prototyping and proof of concepts, which may include: modern programming languages (e.g., Ruby, Python, Node.js) and web frameworks (e.g., Django, Rails), modern front-end web programming techniques (e.g., HTML5, CSS3, RESTful APIs) and frameworks (e.g., Twitter Bootstrap, jQuery), relational databases (e.g., PostgreSQL), and NoSQL databases (e.g., Cassandra, MongoDB), automated configuration management (e.g., Chef, Puppet, Ansible, Salt), continuous integration/deployment, and continuous monitoring solutions; use version control systems (e.g., Git and GitHub); ensure strategic alignment of technical design and architecture to meet business growth and direction, and stay on top of emerging technologies; decompose business and system architecture to support clean-interface multi-team development; develop product roadmaps, backlogs, and measurable success criteria, and write user stories (i.e., can establish a path to delivery for breaking down stories) and clearly communicate and work with stakeholders at every level. | |
Skills Required | The Technical Architect will possess knowledge and experience in analyses and development of conceptual designs and detail designs; developing JBOSS Messaging and connectivity with Spring-JMS connectivity; designing DB schema as per the requirements and in sync with the old system; implementing the daily and weekly jobs that interact with external interfaces; coordinating with business stakeholders to understand their requirements; communicate with cross-divisional personnel at both team and executive levels to understand performance measurement methodologies; and direct team members in compiling business requirements and executing project milestones. | |
Skills Preferred | Skillful in Jenkins, Ansible, MS PowerShell for workflow automation; MS Azure SQL and related Azure technologies; MS SQL Server Always on clustering services on SQL Server 2016 and above. | |
Experience Required | This classification must have a minimum of eight (8) years of experience in systems development, analysis, programming or testing. | |
Experience Preferred | Ten or more (10 ) years of experience performing SQL Server installations, configurations, management and monitoring, and system administration tasks at the level of a SQL Server DBA or similar; Five plus (5 ) years of experience managing a large MS SQL Server farm (300 servers); Five plus (5 ) years of experience developing scripts to automate routine manual database server functions using tools such as Jenkins, Ansible, or similar tools. Five plus (5 ) years of experience migrating and upgrading SQL Server to the latest supported version; experience migrating SQL Servers on premise to MS Azure Five plus (5 ) years of experience building, migrating and managing Azure SQL Managed Instance, Azure SQL DB, and Azure Five plus (5 ) years of experience building, configuring, and managing MS SQL Server Always on clustering services; Five plus (5 ) years of experience working with Commvault Backup client as a tool to perform SQL Server database Backup and Restore including the experience managing SQL Server backup and restore in native SQL Server Management Studio. | |
Education Required | This classification requires the possession of a bachelor s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis. | |
Education Preferred | Possess one of the following certifications: Cloud certifications such as Certifications in Azure Fundamentals and above; Certifications in AWS Cloud Practitioner and above; Certifications in Microsoft Professional certifications; Professional Google Cloud certifications. |