| Database Administrator at Dallas, Texas, USA |
| Email: [email protected] |
| From: Pallavi, nss [email protected] Reply to: [email protected] Title: Database Administrator Location: Dallas, TX Hybrid 3x per week Duration: Ongoing Contract Compensation:$65-68/hour Work Requirements: US Citizen, GC Holders or Authorized to Work in the U.S. Job Details: Lead and execute the cloud migration projects from On-prem SQL Server to Azure SQL, ensuring a smooth transition with minimal downtime. Implement best practices for database security and compliance with data privacy regulations, incorporating access controls, encryption, and auditing mechanisms. Proactively identify and resolve performance bottlenecks, working closely with development teams to optimize query performance, indexing strategies, and resource utilization. Implement and maintain robust monitoring solutions to provide real-time insights into database health, ensuring proactive issue resolution. Conduct regular health checks, capacity planning, and upgrade/migration activities to maintain system reliability and stability. Perform essential database administration tasks, including installation, configuration, monitoring, tuning, backup, recovery, and troubleshooting. Innovate and implement automation solutions for routine tasks, reducing manual efforts and improving operational efficiency. Implement and manage database replication, CDC, Always On, WFC, and high-availability solutions for continuous operation and disaster recovery. Design, implement, and maintain SQL and Azure database solutions aligned with organizational requirements and industry best practices. Design, develop, and enhance ETL processes using Azure Data Factory or other tools to seamlessly integrate data from diverse sources into the database. Collaborate with teams to optimize and streamline data transformation pipelines. Collaborate with the teams to troubleshoot and resolve complex database issues efficiently using Azure Insights, Monitoring, DMVs, Query Store, etc. Demonstrate expert knowledge of SQL, Transact-SQL, DMVs, Stored Procedures, user-defined functions, and Custom Types. Provide expert counsel on database design principles, ensuring the development of scalable, high-performance solutions that align with industry best practices. Offer strategic insights to optimize database structures, enhancing efficiency, and fostering adherence to established best practices. Leverage TSQL, and PowerShell scripting to automate routine tasks, enabling proactive monitoring, maintenance, and issue resolution. Identify opportunities for process improvements and automation, driving initiatives to enhance the efficiency and effectiveness of database administration tasks. Collaborate effectively with cross-functional teams, actively participating in solution design sessions and contributing insights to ensure robust database solutions. Contribute to the development and implementation of best practices for database management in alignment with industry trends. Develop and maintain comprehensive documentation, standards, and procedures to foster knowledge-sharing. Our benefits package includes: Comprehensive medical benefits Competitive pay 401(k) retirement plan and much more! About INSPYR Solutions Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com. INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. 24-01095 Keywords: green card Texas Database Administrator [email protected] |
| [email protected] View all |
| Wed Apr 17 07:53:00 UTC 2024 |