Sorry, this job was closed 2 years ago. See all open Sql Dba Jobs in Pittsburgh, Pennsylvania

Our client is currently accepting resumes for a Sr. SQL DBA position in Pittsburgh, PA. Please see below for additional details...

Location: Pittsburgh, PA
Job Title: Sr. SQL DBA
Job Status: Contract to Hire

Position Summary:
This position will primarily work to support a high volume transactional system as well as a number of dimensional database servers. This role will assist with database management of multiple servers. The candidate will be tasked with server upgrades, performance monitoring/tuning, testing and change deployment. Must be comfortable working in a constantly evolving environment where changing business requirements demand support from the underlying technology. The ability to react decisively and solve complex technical problems is essential to this role.

  • Provide administration support for high volume transactional and dimensional database servers
  • Data modeling (logical and physical) as well as optimization of legacy data models
  • Manage database objects including tables, relationships, stored routines, triggers and users
  • Query optimization including tuning legacy application code and analyzing underperforming query reports
  • Test database components by providing Quality Assurance, benchmarking, validation, monitoring
  • Must be available to provide after hours support in an on-call rotation
  • Provide database support to end users in person, over the phone, and via email as necessary
  • Support development team in crafting clean, efficient & scalable SQL code (stored procedures, triggers and in-line SQL)
  • Contribute to new feature design by designing schema and writing stored procedures
  • Develop data cleanup/?archiving scripts
  • Maintain & monitor DB uptime/?performance monitoring tools
  • Engineer backup/?recovery strategies and associated scripts
  • Capacity planning
  • Sustain "three 9s" up-time goal

Preferred Skills:
  • MySQL, MS SQL, and Oracle experience highly desired
  • Other database (INGRES, PostgreSQL etc) experience also considered for excellent candidates who are able to work hard and learn quickly
  • Bachelor's degree in Computer Science, Information Technology or related field
  • Independent problem solving ability
  • Ability to prioritize multiple tasks and projects and deliver under deadline
  • Exceptional communication, organizational, and interpersonal skills to drive results in a multi-disciplinary environment is required.
  • Understanding of MySQL internals including storage engine architecture (MyISAM, InnoDB, archive), partitioning, indexing, referential integrity, networking and caching
  • Understanding of database replication internal processes including binary/relay logging, replication threads, row/statement based replication, master/slave topologies
  • Familiar with high availability and scalability concepts such as failover and load balancing
  • Understanding of various disaster scenarios, backup/disaster recovery techniques/topics including logical/physical backups, point-in-time recovery, data corruption
  • Experience with Linux operating systems (CentOS), Bash shell scripting, installing/upgrading software, security, understanding of Linux file system architecture
  • Familiar with database transactions and concepts: table/row locking, semaphores & mutual exclusion, ACID, disk I/O
  • General knowledge of hardware components and connectivity including disk, CPU, networking, memory, switches, etc.

About Synergy Staffing Inc.:

Synergy Staffing, Inc. is an innovative leader in the Western Pennsylvania recruiting and placement industry. We are committed to understanding our clients needs and providing solutions that not only meet, but exceed their expectations. We match thoroughly vetted candidates to Contract, Contract-to-Hire, and Permanent positions in the Information Technology and Professional Services industries.

Browse sql dba jobs in Pittsburgh, Pennsylvania:

Get jobs like these daily:

See all open Sql Dba Jobs in Pittsburgh, Pennsylvania

Back to Top