*Position: Senior Data Architect* *Location: Atlanta, GA *
*Duration: 6 Months* * * *CLOUD experience is required* *Senior Data Architect / DBA - SQL Server 08* *Primary responsibilities:* - Logical Database design? Assist in the logical database design with the stakeholders, refine the design based upon the Business Architecture logical design - Physical Database design? develop an efficient and effective physical DB design including physical implementation requirements and tuning - DR and High Availability Strategy and Design? Develop the strategy and design to ensure high availability and align with the Disaster Recovery Plan. - Performance and Volume Strategies? develop strategies for high volume and high performance tuning and considerations - Data Layer Implementation Strategies? Develop strategies for the implementation of the data layer for use in developing the BTP applications. - Analytic Data Strategies and Design including ETL / ESB Considerations? develop the strategy and design to create the analytic data stores / data warehouses for data from the BTP transactional systems - Metadata Management Strategy and Design? Develop data dictionary strategies for both transactional and analytic data - Develop Release Management strategy and Processes? Develop the release strategy for the transactional databases - Legacy Integration Strategy Development? develop strategies, if applicable, to integrate the new databases with the legacy applications - CLOUD experience is required *Summary of DBA Activities* - Data modeling and database design. The DBA must possess the ability to create an efficient physical database design from a logical data model and application specification. Since the data resource management discipline has not been created, the DBA also must be responsible for data modeling, normalization, and conceptual and logical design. - Metadata management and repository usage. The DBA, or sometimes the Data Architect (DA), must collect, store, manage, and enable the ability to query the organization's metadata. - Database schema creation and management. The DBA must be able to translate a data model or logical database design into an actual physical database implementation and define procedures to manage that database once it has been implemented. - Backup and recovery. The DBA must implement an appropriate database backup and recovery strategy based on data volatility and application availability requirements. - Ensuring data integrity. The DBA must be able to design databases so that only accurate and appropriate data is entered and maintained. To do so, the DBA can deploy multiple types of database integrity including entity integrity, referential integrity, check constraints, and database triggers. Furthermore, the DBA must ensure the structural integrity of the database. - Performance management and tuning. Dealing with performance problems is usually the biggest post-implementation nightmare faced by DBAs. As such, the DBA must be able to proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance. - Ensuring availability. Applications and data increasingly are required to be up and available 24x7. The DBA must be able to ensure data availability using non-disruptive administration tactics. - SQL code reviews and walk-through. Although application programmers usually write SQL, DBAs usually are blamed for poor performance. Therefore, DBA must possess in-depth SQL knowledge so they can understand and review SQL and host language programs and to recommend changes for optimization. - Procedural skills. Modern databases manage more than merely data. The DBA must possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions that are stored in the DBMS. - Data security. The DBA is charged with the responsibility to ensure that only authorized users have access to data. This requires the implementation of a rigorous security infrastructure for production and test databases. And a database auditing capability to document compliance. - Capacity planning. As data consumption and usage continue to grow, the DBA must be prepared to support more data, more users, and more connections. The ability to predict growth based on application and data usage patterns and to implement the necessary database changes to accommodate the growth is a core capability of the DBA. - Web-specific technology expertise. For e-businesses, DBA is required to have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications. Examples of this type of technology include XML, CGI, Java, Ruby on Rails, TCP/IP, Web servers, firewalls, SSL, and so on. *Kind Regards,* *Nelson* *P-Calyxsis Technology Solutions LLC* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Software Testing" group. To post to this group, send email to software-testing@googlegroups.com To unsubscribe from this group, send email to software-testing+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/software-testing -~----------~----~----~----~------~----~------~--~---
