SQL Server DBA
Company: Cygnus Professionals Inc.,
Posted on: October 10, 2018
new position 12/26 - SMI_SSD_846 Client: State of MI - Direct Rate: $75/hr on C2C Job Title: SQL Server DBA Location: Lansing MI 48933 Duration: 12 Months Position Type: Contract Interview Type: In Person Only Required Skills: * SQL Server 2008, 2014 experience. Database administration, data m= odeling, configuration, security Required 4 = Years * Resource Monitoring Required 4 Year= s * SQL Scripting Required 2 Years * Extract, Transformation and Load processes Required = 4 Years * Experience working with datawarehouse Required = 2 Years * Performance tuning Required 2 Yea= rs Question 5 The client plans to schedule IN PERSON ONLY interviews = for this position January 4rth and 5th. Please confirm your candidate will = be available to interview any of those days if selected. Job Description: Responsible for data analysis and database management. Involved in maintena= nce, enhancement, designing of data dictionaries, physical and logical data= base models, and performance tuning. Years of Experience: 8-11 years of experience in the field or in a related area. Job Description: Relies on experience and judgment to plan and accomplish goals, independent= ly performs a variety of complicated tasks, a wide degree of creativity and= latitude is expected. *Responsible for data analysis and database management. Involved in mainten= ance, enhancement, designing of data dictionaries, physical and logical dat= abase models, and performance tuning. Knowledge of the utilities and produc= tion tools used for data storage management to support the Application Team= Coordinates physical changes to computer databases; codes, tests, and imp= lements physical database, applying knowledge of data base management syste= m. Designs logical and physical databases reviews description of changes to= database design to understand how changes to be made affect physical data = base (how data is stored in terms of physical characteristics, such as loca= tion, amount of space, and access method *Establishes physical database parameters. Uses structured query language (= SQL) to define database objects using database definition language (DDL) an= d control access to database objects using data control language (DCL La= nguage descriptions and specifies identifiers of database to database manag= ement system or directs others in coding database descriptions. Calculates = optimum values for database parameters, such as amount of computer memory t= o be used by database, following manuals and using calculator. Specifies us= er access level for each segment of one or more data items, such as insert,= replace, retrieve, or delete data. Specifies which users can access data b= ases and what data can be accessed by user. Tests and corrects errors, and = refines changes to database. *Enters SQL to create production data base. Uses database utility programs = and 3rd party utilities to monitor database performance, such as distributi= on of records and amount of available memory. Directs programmers and analy= sts to make changes to data base management system. Reviews and corrects pr= ograms. Answers user questions. Confers with coworkers to determine impact = of data base changes on other systems and staff cost for making changes to = data base. Modifies data base programs to increase processing performance, = referred to as performance tuning. Workers typically specialize in one or m= ore types of data base management systems. Providing assistance in the plan= ning, development, maintenance, and monitoring of integrated database syste= ms, and ensuring that the conceptual and design phases of new applications = are consistent with the structural parameters within the database environme= nt. *Evaluates users'' requests for new data elements and systems, incorporates = them into the existing shared data environment, and provides technical assi= stance. Coordinates the use of data to ensure data integrity and control re= dundancy, loads databases, and reorganizes as needed. Performs data modelin= g and prototyping. Performs logical and physical data modeling, designs rel= ational database models, and creates physical data models from logical data= models. Performs security recovery procedures. Determines and implements d= atabase search strategies and storage requirements. Maintains data dictiona= ry ensuring uniformity of definitions and sets standards for use of data di= ctionary. Monitors database performance and recommends efficiency improveme= nts. Creates test database environment for applications section, including = the creation of necessary libraries and procedures. *Executes the procedures necessary to save, retrieve, and recover databases= from hardware and software failures within established procedures. Assists= with determining, implementing, and enhancing standards on database securi= ty and with monitoring agency disaster recovery procedures and systems. Ass= ists with the installation of database software and with analyzing, designi= ng, and implementing databases. Assists in benchmarking and threshold testi= ng of databases and with establishing and controlling necessary database se= curity. Assists in the selection of database management software. Experienc= e in computer systems analysis or computer programming work. *Knowledge of the principles, practices, and techniques of computer program= ming and systems design; of computer operations, systems, and procedures; o= f project control and cost estimating techniques; of computer programming l= anguages; of data processing flowcharting techniques; of database structure= s and theories; and of current database technologies.
Keywords: Cygnus Professionals Inc.,, Lansing , SQL Server DBA, IT / Software / Systems , Lansing, Michigan
Didn't find what you're looking for? Search again!