| URGENT CLOSURE REQUIREMENT|| SQL DBA MID LEVEL || C2C REMOTE at Remote, Remote, USA |
| Email: [email protected] |
| From: Manikanta, jupitertechnologies.net [email protected] Reply to: [email protected] URGENT CLOSURE REQUIREMENT|| SQL DBA MID LEVEL || C2C REMOTE Visa: USC AND GC CANDIDATES only Exp : 10+ Role: .SQL DBA Location: Remote Client: Winsen Exp : 10+ Rate : 60 ( No Negotiation ) Top must have skills: Technical Microsoft shop- SQL, Maker & Crystal Reports. MCDBA, CMDBA certs. Soft professionalism, able to work cross functionally. Most likely will be a junior to mid-level candidate) Job description: SQL is a must as they are an all Microsoft shop. Essential Duties and Responsibilities: Implement data models, database designs, data access and table maintenance codes. Resolve database performance, replication, capacity, and other distributed data issues. Consult with various institutional departments to define needs and refine system to maximize multipurpose uses. Serve as subject matter expert on technical projects which may include the evaluation, decision making, implementation and some aspects of support on third party solutions. Build stored procedures and views (building SQL SSIS and Jobs). Write reports in Info Maker and Crystal Reports High availability strategies including clustering, replication, database mirroring, availability groups and log-shipping. Performs routine performance and availability testing on database servers to ensure scalability, resiliency, and capacity of all applications. Assists in the architecture of database systems for high volume database applications with high availability requirements. Production support for all mission critical databases in the organization. Database server installations, patches, and upgrades, including both standalone and clustered server environments. Database deployments and post validation testing. Database Maintenance best practices including index rebuilds, distribution statistics and database consistency checks. Backups, recovery and recovery testing and verification. Database performance tuning activities such as analyzing MS SQL query plans, index tuning, troubleshooting database blocking and resolving deadlocks. Experience creating and maintaining a data warehouse. Skills and Qualifications: Familiar with standard concepts, practices, and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. Strong knowledge of databased security best practices. Strong knowledge and experience with stored procedures and SQL queries and optimizing them to improve overall database performance. Working knowledge of modern data network technologies, enterprise storage technologies, (SAN, NAS etc.), server consolidation technologies, server virtualization technologies and disaster recovery technologies. MCDBA, CMDBA or equivalent technical certification preferred. Works under general supervision. Keywords: green card microsoft |
| [email protected] View all |
| Thu Jul 20 22:34:00 UTC 2023 |