Job Description :
Title: Database Administrator (Junior) Duration: 1 Year + Location: Hanover, Maryland Job Description The candidates should have at least three (3) years' experience in the following: A. Experience in Database administration with DBMS platforms including: the management of data, tables, views, indexes, triggers, constraints, primary keys, foreign keys, rules, stored procedures, functions, data types, users, roles, logins, file groups, files, storage, Data Manipulation Language (DML), Data Definition Language (DDL) and other related items. B. Experience with DBCCs, ODBC, SNAC, Middleware, database and transaction log backups, scheduled jobs, batch programs, scripts, performance, concurrency, security, redundancy, and other related items. C. Experience with different versions of DBMS, analytic and reporting services, mirroring, virtualization and log shipping, replication. D. Knowledge of and experience with database architecture, design, development, and best practices including high availability, disaster recovery, normalization to third normal form, query optimization, logical models, physical models, referential integrity, and domain integrity. E. Experience with third party data base modeling tools (including Visual Studio for Enterprise Architects, Erwin, Visio) and other similar third-party software tools. F. Experience with specifying, installing, configuring, and supporting related hardware platforms including multiprocessor servers, RAID\SAN storage technology and backup solutions. G. Experience installing, configuring, and utilizing server and desktop operating systems. H. Experience configuring and utilizing Active Directory. I. Experience with Trapeze software applications that are used to support critical business functions for both fixed route buses and mobility services. Responsibilities: The Personnel shall perform the following requirements: Ensure servers are current with DBMS patches and security updates. Configure and tweak the hardware and software, perform integration testing, create, and restore server images, create, and implement plans to rollover the statewide systems from testing to production. Install and upgrade database server and other related software on the specified hardware to provide functional capabilities for the critical systems. Assist business side system administrators on database issues/errors and assist users and programmers with SQL queries and tuning. Conduct routine maintenance tasks on the database servers for proactive monitoring like deleting log files, dump files, error correcting. Troubleshoot problems related to availability of data to system users, space, database software, dataflow, and data storage or data access. Attend internal staff meetings as requested with network team, project managers, business users, developers, and upper management. Work in cooperation with the current Network Management Systems contractor as well as other contract vendors and team members. Create or review Configuration Change Requests, Work Breakdown Structures, Implementation Plans, and Testing Plans for Microsoft SQL Server and Access database projects. Create or provide appropriate input to monthly project status reports. Participate in the creation of or review hardware and software requirements for database systems. Configure a backup job to run on a specified schedule. Restore data files or tables from a previous backup session. Performed other related duties as assigned by the management.