Previous Job
Previous
Senior DB2 DBA
Ref No.: 17-00994
Location: South of Providence, Rhode Island
Position Type:Contract
Position Type: 12 Month Contract with the possibility for 12 month extensions

We are in Search of a Senior DB2 DBA.  This person will be responsible for:
  • Managing all levels of the physical database design, implementation, maintenance and support functions on database platforms for all types.
  • Providing technical assistance in identifying, evaluating, and developing systems and procedures as they relate to databases
  • Leading the design of data dictionaries, database structure/layout, installation, upgrades, and management of database applications.
  • Developing the maintenance strategy, maintenance scripts, and design the migration paths from older versions of DB2 to the latest releases
  • Ensuring accuracy and availability of data.
  • Understanding database backup/recovery procedures and how to develop/operate a cost-effective data base.
  • Establish policies and procedures pertaining to database management, security, maintenance and utilization.
  • Analyzing database performance statistics, perform required tuning activities to optimize database performance.
  • Instructing programmers in application design, database design and coding/debugging of SQL statements
  • Advising the development teams in the correct design of database sizing in various environments (dev, APL, test, production, etc.)
  • Recommending continuous improvement in database administration environment.
Required Skills:
  • In-depth knowledge of SQL and database performance optimization.
  • Experience with DB2, Oracle, MySQL and SQL Server 2000.
  • DBA experience in multiple operating system environments, to include Windows 2000, Linux, and AIX, Experience with DB2 8.1, 9, 10, 11.
  • Experience with MySql
  • Experience with Oracle to DB2 migrations
  • Experience with Ctree Experience in optimizing SQL queries generated by ORM frameworks like hibernate Self-starter
  • Ability to work with Customers and understand their requirements.
  • Experience with Liquibase is desirable Good communicator.
  • Experience working with Enterprise level systems requiring high levels of performance and availability
  • Experience working with local and remote DB recoveries