*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:- [email protected] <[email protected]>
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
"OracleD2K" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/oracled2k.
For more options, visit https://groups.google.com/d/optout.
