Database Administrator
Yoh
(Austin, Texas)Job Posting Details
About Yoh
Yoh covers the diverse talent and workforce management needs in the Aviation, Engineering, Health Care, IT, Life Sciences, Media & Entertainment and Telecom industries. You can be confident that we have the right talent and managed solution for you. You need it. Yoh has it!
Summary
Database Administrator needed for a contract opportunity with Yoh's client located in Austin, TX.
Responsibilities
- Installing and upgrading the database server and application tools
- Allocating system storage and planning future storage requirements for the database system
- Modifying the database structure/ Schema Changes, as necessary, from information given by application developers
- Enrolling users and maintaining system security
- Controlling and monitoring user access to the database
- Monitoring and optimizing the performance of the database
- Maintaining archived data
- Backing up and restoring databases
- Generating various reports by querying from database as per need
- Creating/ Update/ Review - SQL Application Queries
- Data Mapping
Ideal Candidate
**Skills and Tools required for Microsoft SQL Server 2012:**
- Management Tools - Management Studio, SQL Profiler, SQL CMD, SQL Agent, Tuning Advisor
- Programmability & Development Tools - T-SQL Queries (DML, DDL, TCL), SQL Data Tools
- Security - User, Roles, Auditing
- High Availability - Database Backup & Restore, Log Shipping,
- Scalability and Performance - Indexing, Partitioning
- RDBMS Manageability - PowerShell Scripting, Performance Report, Index Maintenance
- Integration Services - Configuration, Import - Export, SSIS Designer, Data Profiling, Transformation
- Reporting Services - Report Server Configuration
- Data Modeling - Erwin (CA) and/or ErStudio (Embarcadero)
- Microsoft Office 2013 - Word, Excel, Visio
- Apache Subversion (SVN) - Versioning and Revision Control System
**Environment:**
- Microsoft Server 2012
- VMware Environment
**What You Need to Bring to the Table:**
- SQL Server 2012 - Replication, Analysis services
- Certification - MCDBA or MCSA
- Must pass a TRS Background Check
Questions
There are no answered questions, sign up or login to ask a question
Want to see jobs that are matched to you?
DreamHire recommends you jobs that fit your
skills, experiences, career goals, and more.