Job Title | Sr. BI/ SQL DBA |
Project Location | Atlanta, GA |
Duration | 6+ Months Contract |
Interview Process: - Phone + F2F
Visa: Any
Job Description
I have the requirements below but we are looking for someone that has experience with a new setup of Teradata.
Must Haves:
- 6+ years SQL DBA experience
- 3+ years Teradata experience
- 3 years' experience working with various database management systems in database design, testing, implementation, maintenance and administration
- Experience developing database designs and creating database schemas
- Extensive experience with:
- Capacity planning
- Database: implementation, monitoring, testing, upgrades, and replication
- Disaster recover planning experience
Plus Skills:
· Hadoop
D2D:
They are building out a whole new operational data store as well as a new enterprise data warehouse
They are in the beginning stages of all of it and just now getting Teradata online and starting to gather business requirements and map it all out!
Creates databases, resolves problems and manages database integration activities; provides DBA consulting and support to business and technology partners; provides support in database design activities including data modeling and schema creation; maintains standards and review of code to meet standards; reviews code for performance; supports production environment by researching errors and performance issues; Monitors and optimizes database performance; assists with data model maintenance and updates; assists other teams with best practices and troubleshooting including system administrators, security administrators and auditors.
Sr. BI Database Administrator
Job Summary
Creates databases, resolves problems and manages database integration activities; provides DBA consulting and support to business and technology partners; provides support in database design activities including data modeling and schema creation; maintains standards and review of code to meet standards; reviews code for performance; supports production environment by researching errors and performance issues; Monitors and optimizes database performance; assists with data model maintenance and updates; assists other teams with best practices and troubleshooting including system administrators, security administrators and auditors.
Principal Duties & Responsibilities
- Works with data architects and developers to develop database designs; ensures that physical data model is normalized to match client specifications and established procedures
- Creates databases and schemas from internally developed designs
- Assists with maintenance to SQL standards; enforces standards as required
- Reviews code for conformance to standards and performance
- Reviews execution plans and implements schema changes to increase performance as necessary including indexes and partitions
- Assist in application support of new and existing systems; database capacity planning; exploring and implementing new database technologies and tools
- Supports the database analyst in maintaining the physical data model and controlling the physical database definition according to business rules and structure
- Coordinates the installation of application and database system upgrades as well as additions to the data dictionary
- Establishes and maintains the data repository; creates, modifies, and installs catalogs and reports on servers across the company
- Develops database backup and recovery procedures
- Provides training to database administrators and other operational or application support teams
- Implements new data technologies and releases; assists in evaluation of database administration tools that will increase database efficiency
- Balances the optimization of data access with batch loading and resource use factors
- Works closely with analysts to recommend, develop, and implement measurements for systems performance against expectations
- Implements program performance specifications; provides support for clients accessing data stored in DBMS and data warehouses; supports the development of stored procedures and triggers
- Interfaces with database administrators, database analysts, and vendors involved in the initial planning stages of projects and make recommendations on medium to high complex data structures for reporting and analysis queries
- Provides input to integrated logical data model, minimizing data element redundancy, and maximizing the compatibility and usefulness of data; communicates and validates modeling issues to a variety of audiences
- Supports the analyst in responding to events on the database to ensure compliance with service level agreements
- Assists the analysts in planning data structure for DSS/EIS
- Supports multiple servers and multiple databases of medium to high complexity, with multiple concurrent users, ensuring control, integrity, and physical accessibility of the data
- Designs and builds security structure needs for the DBMS or data warehouse; performs reporting tool security
Thanks & Regards,
Udbhav Mathur
Talent Acquisition Specialist
Email:- umathur@tekshapers.com
Gtalk: udbhav.intime
Tekshapers Inc. – WMBE Firm
1441 E. Maple Rd, Suite # 301, Troy, MI 48083
Certification: WMBE Certified | E-Verified Company | ISO 9001:2008
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment