Senior SQL Database Administrator (DBA)
The Data Base Administrator is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company.
The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. This individual will help to trains and develop technical support and applications staff to better utilize on-line processing databases. He/she will provide and designs tools to assist in the management of the database and transaction processing environment and will work towards providing a working model of our transaction processing environment for capacity assessment and planning.
Senior SQL Database Administrator (DBA) Job Duties:
- Maintains system level entity relationship diagrams, translates business requirements into transactional database schema designs, assesses the appropriateness of replicated data, and verifies compatibility of database tool and application software packages with existing database architectures and standards.
- Maintains meta data, administers the development and staging environments data repository, determines data types, optimizes the physical database design for the specific DBMS, and approves schema changes, call patterns, and SQL code.
- Codes and installs changes to the database schema, stored procedures, and replication processes utilizing DBMS- or package-specific techniques as appropriate.
- Develops and executes procedures to validate changes to the database infrastructure.
- Prepares required documentation and participates in change control, works with production database administrators to migrate schema and stored procedure changes to Production and participates in the verification processes.
- Responsible for the modeling, definition, creation, and maintenance of the database resource.
- Works closely with a team of developers and is involved in design decisions.
- Provides developers consulting on performance and optimizing SQL scripts.
- Creates or reviews data models.
- Reviews and tests new technologies and architectures that support and are aligned with applications
Typical Job Requirements
- 5+ years Microsoft SQL 2005, 2008
- 3-6 years of experience building system solutions, working as a member of a multidiscipline team, utilizing formal development methodologies.
- 3-6 years of experience in Data Analysis, Database Administration, or Database Replication in a high volume multi-platform transactional environment; experience with data warehousing technologies is desirable.
- Ideally 3-6 years of development and enforcement of data management policies, standards, and procedures.
- Conceptual knowledge of project management techniques is required.
Good to Have
- Advanced knowledge of writing SQL scripts
- In-depth knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) and best practices
- Experienced in data modeling.
- Exposure to UML or other associated object orientated design methodologies.
- Demonstrates a strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation.
- Strong experience of relational databases, backup and restore operations, DB logins/permissions, stored procedures, schema, triggers, database maintenance activity, etc.
- SSIS development
- N-tier Architecture
- Remote Procedure Calls (RPC), store procedures
- Java, Cold Fusion (preferable), JavaScript, J2EE programming skills
