Sr. BI/ SQL DBA || Atlanta, GA || 6+ Months Contract || phone+ F2F- Need Local

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 

http://www.tekshapers.com

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.