Hi,
We have an opening for………………… Position: SQL Server DBA / Data Architect Location: Concourse Parkway Atlanta, GA Duration: 3 Months 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 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. Contact No: E-mail ID: Availability: Visa Status/Citizenship: Current Location: Rate or Employer Details: Regards, Gaurav Resource Manager Ling Technologies, Inc. I 9161 Liberia Ave, Suite 200 Manassas, VA 20110 Work: 703-880-2641 Extn: 204 I Fax Toll Free 866-473-6904 I <mailto:[email protected]> [email protected] <mailto:[email protected]> I <http://www.mail2web.com/cgi-bin/redir.asp?lid=0&newsite=http://www.ling-tec h.com/> www.ling-tech.com I IM [email protected] (No Emails on these IDs Please): I [email protected] Disclaimer: We respect your Online Privacy. This is not an unsolicited mail. Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a REMOVE in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses which might be diverting the e-mails to you or click on this link to be removed. Remove link: mail to <http://www.mail2web.com/cgi-bin/compose.asp?mb=inbox&mp=I&mps=1&lid=0&intLi stPerPage=20&ed=yWqIig6kAEXMbfqWN9QPG8o8mJKR%2BXVqwKSvjjReOhppgzo365Vkuqbcp% 2F4%2BBBdKbIM5H5%2FE%2FBzH%0D%0AdtlYIbONgBb%2Fa0PIWczfNwFJ6FQ9x0vDypqp6FFd33 9ycG8Rpv6HrdNkvfaJlybPUoM%3D&[email protected]> sender. We are sorry for the inconvenience. CONFIDENTIALITY NOTICE: This confidential message/attachment contains information intended for a specific individual(s) on Staffing/Consulting/Recruitment purpose and it may contain confidential, proprietary or legally privileged information of Ling Technologies Inc. Any inappropriate use, inappropriate distribution or inappropriate copying is strictly prohibited. If received in error, notify the sender and immediately delete the message. Neither this information block, is the typed name of the sender, nor did anything else in this message intend to constitute an electronic signature, unless a specific statement to the contrary is included in this message. P Please consider the environment before printing this e-mail. _____ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "jobinusa" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jobinusa?hl=en -~----------~----~----~----~------~----~------~--~---
