MS SQL DBA

The Altip Group; Reston (VA); On-site; USD 95,000 - 130,000; Full time

Job summary

The Altip Group seeks a Database Administrator to oversee the database environment for high reliability and performance of online processing systems. You will collaborate with IT, architecture, applications, and operations to design a state-of-the-art database environment that supports current and future business objectives.

You will develop methods for ongoing performance assessment, manage security, disaster recovery, and play a key role in production applications, capacity planning, and

Qualifications

• Degree in Computer Science, Business Administration, Information Technology or related field preferred
• 3+ years IT operations with strong understanding of database structures, theories, principles, and practices
• 3+ years Microsoft SQL Server experience
• Understanding of server-client computing and relational database environments
• Experience with data management and data processing flowcharting techniques
• Knowledge of reporting and query tools and practices
• Good interpersonal, written, and oral communication skills
• Technical documentation skills
• Ability to present ideas in user-friendly language
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment
• Good written and oral communication skill

Responsibilities

• Ensure availability and performance of the databases supporting the system
• Maintain hardware resources allocated to databases for high resilience and performance tuning
• Proactively monitor database systems for secure services with minimal downtime
• Provide trend analysis to management for resource decisions
• Troubleshoot and solve SQL development issues
• Improve and maintain databases including upgrades
• Implement and release database changes per timelines
• Install, configure and upgrade SQL Server/MySQL/Oracle servers
• Evaluate MSSQL features and related products
• Establish and maintain backup and recovery policies
• Implement and maintain database security (users/roles/privileges)
• Tune databases and queries; monitor performance
• Support application tuning and performance monitoring
• Create and maintain documentation and standards
• Plan growth and capacity changes
• Provide 7×24 support when required
• Troubleshoot and consult with development teams
• Interface with vendors and internal staff for support
• Work with IT and Hosting teams on optimal configuration/tuning of infrastructure
• Carry out other responsibilities as assigned
• Create, monitor and optimize data extracts, ETLs, and other database jobs/processes
• Assess production impact of proposed changes and support change management
• Participate in development standards for DBA administration and maintenance

Skills

SQL Server

Database design

Performance tuning

Backup & recovery

ETL processes

SQL scripting

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server 2005/2008R2

MySQL

Oracle

ITIL

Job description

The database administrator (DBA) is responsible for providing technical support forthe database environment including overseeing the administration and organization ofthe databases, assessment and implementation of new technologies, and providingInformation Technology with a long-term perspective on the relationship of databasetechnology to the business opportunities facing the company. It is extremely importantto the company that on-line processing database systems offer the highest reliabilityand performance possible. The DBA is challenged to work with architecture, applicationdevelopment and operations to help achieve a state-of-the-art environment that meets
current and future business objectives. Evaluates, provides and designs tools to assistin the management of the database and transaction processing environment. The DBAworks to provide a working model of our transaction processing environment for capacityassessment and planning.

The individual develops a methodology for the ongoing assessment of database
performance and the identification of problem areas. Develops and manages securityscheme for the database environment, as well as assisting in disaster recovery ifnecessary. Provides leadership during the development and nhancement of productionapplications including working with applications, technical support and operations duringthe design, development and implementation of applications. Work with the transactionprocessing area to develop both the physical and the logical database administrationfunctions and assists in the development of our processing database and computing
environments. Work with others in IT to build the logical database area and providetechnical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.

REQUIRED EXPERIENCE

• Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
• 3+ years IT operation with strong understanding of database structures, theories, principles, and practices
• 3+ years Microsoft SQL Server experience
• Understanding of, and experience with, server-client computing and relational database environments
• Experience with data management and data processing flowcharting techniques
• Knowledge of reporting and query tools and practices
• Good interpersonal, written, and oral communication skills
• Technical documentation skills
• Ability to present ideas in user-friendly language
• Self-motivated and directed, with keen attention to detail
• Able to prioritize and execute tasks in a high-pressure environment
• Experience working in a team-oriented, collaborative environment
• Good written and oral communication skill

RESPONSIBILITIES

• Responsible for ensuring availability and performance of the databases that support the system.
• Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning.
• Proactively monitor the database systems to ensure secure services with minimum downtime (SQL Server 2005/2008R2).
• Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
• Responsible for troubleshooting and problem solving of SQL development.
• Responsible for improvement and maintenance of the databases to include rollout and upgrades.
• Responsible for implementation and release of database changes according to agreed timeframes.
• Installation, configuration and upgrading of Microsoft SQL Server/MySQL/Oracle server software and related products.
• Evaluate MSSQL features and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Database and query tuning and performance monitoring.
• Application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 7×24 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Interface with external vendors, internal staff for technical support.
• ITIL Skill set requirement (Problem Management/Incident Management/Chain Management etc)
• Work with IT and Hosting team on optimal configuration/tuning/configuration of SQL and associated infrastructure/ (hardware/network/SAN, etc) to assure optimal performance of the client applications disk configuration
• All other responsibilities as assigned
• Create, monitor and optimize data exactions, ETLs and other database jobs/processes to assure reliability, and optimal performance of client products and services
• Assess production impact of proposed changes in database environment and support the change management deployment and rollback process as necessary
• Participates in development standards and practices for DBA administration and maintenance.