| Urgent position || MS-SQL Database Administrator @Alabama. at Montgomery, Alabama, USA |
| Email: [email protected] |
| Direct client position Position: MS-SQL Data Base Administrator Duration: 1 Year Location: Montgomery, AL (Onsite) Client: State of Alabama Department: Department of Human Resources Position Description: SQL Server Database Administrator responsible for all aspects of database administration and data solutions. Maintains standard and enterprise Microsoft SQL Server 2012 through 2019 data environments and detailed technical components on Hewlett-Packard (HP) physical and virtual servers running Microsoft Windows Server 2012 through 2019 operating systems. Manage data environments observed by competency in complex legacy SQL code modernization and concurrent new development. Ability to intelligently organize and document data processes is a must. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on database management systems, configures database parameters, and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost. Must also attend and participate in all assigned project onsite meetings. Required Skills: Must have experience performing standalone installation, adding features to an existing installation and the upgrading of an existing instance of SQL Server to different edition. Working knowledge of the SQL Server Installation Center for maintenance. Ability to comprehend and author complex and extensive SQL script is a must, with the expectations of maintaining and rewriting legacy processes to accommodate versioning and infrastructure changes. SQL programming skills should be denoted via efficient and effective syntax, acceptable peer code reviews, demonstrable product results, and documentation principles. Should be extremely proficient with Data Manipulation Language (DML), Data Query Language (DQL), Data Definition Language (DDL), Data Control Language (DCL) and SQL Server Integration Services (SSIS) Packages as well as data management concepts such as normalization, aggregation, concurrency, and data modeling, to include data interchange formats such as JavaScript Object Notation (JSON). Security driven concepts are top priority in all development and applied against standards set by the National Institute of Standards and Technology (NIST), Microsoft Trust Center (Azure Compliance) and any internal Departmental policies. Strong expertise in Data Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality, Functions, Views, and Triggers. Azure Cloud Services, BLOB Storage, SQL Data Tools, SQL Reporting Services and Amazon Web Services (AWS) are additional resources that the candidate should have work related experience with. Must possess superior communication and documentation skills, strong decision making and organizational attributes along with exceptional analytical and problem-solving skills. Will work closely with Project Management, Application Designers, Peer Data Administrators and Project Owners in workflow and business rule discovery, application design assistance, data modeling, and any applicable project related implementation of process controls. Preferred Skills: In Addition to the required skills listed above, the candidate may be required to utilize the following software: Redgate SQL Monitor for MS SQL Server and Oracle, Advanced Query Tool (AQT), and Quest Toad for DB2. May be asked to assist in the support and maintenance of DB2 11.5 LUW (Windows), DB2 12.0 z/OS and/or ORACLE systems, therefore skills related to some or all of the software and/or platforms are preferred but are not required. Required Experience: 5 to 10 years of experience working with various database management systems in the areas of database design, testing, implementation, maintenance and administration in a multiple platform environment and Required minimum of 5 years of experience in the role of a lead Microsoft SQL Server database administrator. Experience required shall relate to the Skills Required section outlined in the Position Details within this requisition request. Education Required: Bachelors Degree in: Computer Science, Information Systems, - OR - other related field with supporting work experience related to the Skills Required and Skills Preferred. Best Regards, TechNix LLC Tanushree Joshi Mail: [email protected] , www.technixonline.com Direct: 949-686-0786 Phoenix, AZ, 85050 Linkedln: https://www.linkedin.com/in/tanushree-joshi-574276212/ Note: We respect your online privacy. If you would like to be removed from our mailing list, please reply with "Remove" in the subject and we will comply immediately. We apologize for any inconvenience caused. Please let us know if you have more than one domain. The material in this e-mail is intended only for the use of the individual to whom it is addressed and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended recipient, be advised that the unauthorized use, disclosure, copying, distribution or the taking of any action in reliance on this information is strictly prohibited. We are an equal opportunity employer with a diverse workforce. Technix LLC | Phoenix, AZ | phoenix, AZ 85050 US | Update Profile | Constant Contact Data Notice Keywords: zos information technology hewlett packard microsoft Alabama Arizona Urgent position || MS-SQL Database Administrator @Alabama. [email protected] |
| [email protected] View all |
| Wed Aug 14 19:15:00 UTC 2024 |