Database Developer/Adminstrator
Guidance - Marina del Rey, CA

This job posting is no longer available on Indeed. Find similar jobs:Database Developer Adminstrator jobs - Guidance jobs

MICROSOFT SQL SERVER DBA
As our DBA you will ensure database performance for client projects by planning, designing, developing, managing, maintaining, and securing databases according to Guidance standards.

Responsibilities:

  • Design database architecture for client projects which include ecommerce sites, intranets, extranets, software applications, and data warehouses
  • Confirm database requirements by communicating with internal and external team, including Project Managers, Developers, and clients; studying operations and objectives; integrating enterprise requirements; applying database concepts and functional capabilities
  • Troubleshoot database issues to support client projects and ensure database functionality at all times.
  • Develop Data Flow Diagrams, Entity Relationship Diagrams and Data Structure Plan for database growth, capacity planning and scalability
  • Perform database development/implementation activities
  • Configure, tune and maintain SQL Server database servers
  • Ensure 24/7 database availability, reliability and security during production
  • Maintain database performance by developing tuning methodologies
  • Maintain data integrity by consistently applying Guidance’s database design methodology, monitoring performance, and performing tuning techniques
  • Maintain design structure by implementing SQL standards and guidelines
  • Complete platform upgrades and migrations, monitor performance, and coordinate actions with team members
  • Collect, analyze and summarize database performance and trends
  • Respond to client calls regarding database issues and inquiries

Experience/Skills:

  • 8-10+ years SQL Server experience. 5+ years’ experience with SQL 2005/2008
  • Fluency in SQL and Transact SQL and writing stored procedures
  • Proven success in creating Logical and Physical Data Models from user requirements
  • Knowledge of relevant configuration parameters to tune the database for reads/writes
  • Hands-on experience monitoring a running database and performing tuning processes
  • Experience in planning for database growth, capacity planning and scalability
  • Excellent verbal and written communication skills; in compassing a proven track record of conversing with both technical and non-technical audiences
  • Development and deployment of MS SQL Server Integration Services packages (SSIS)
  • Knowledge of SQL Reporting Services (SSRS) and SQL Analysis Services (SSAS) a plus

Education

  • BS in Computer Science or related field or equivalent work experience
  • Microsoft Certification a plus