#hiringalert #c2crequirements #c2cjobs #highpriority #DatabaseAdministrator #requirements !!!! #Knacksoft Please share Profiles to pratapkammili@knacksoft.com Title : Database Administrator (WORF-ISD23016-01) Client : JCC - Judicial Council Courts Work Location City: Remote Work State : N/A Description : · Are you looking for someone who has a robust Oracle background along with experience in other databases? - Yes, along with experience in one or more databases like Maria DB, MY SQL, Azure SQL Do you have a specific Oracle DB version preference? When migrating from Oracle, which cloud platform do you tend to favor? - Oracle 12c and above. Azure platform Minimum Job-Specific Skills/Qualifications Required (in order of relative importance): • 5+ years’ experience designing complex, normalized, relational application databases, including Oracle. • 5+ years’ experience designing, developing, and deploying relational databases in a cloud environment, especially Azure and/or AWS, ensuring the integrity and security of the database. Experience migrating an on-premises or cloud Oracle DB to any one cloud-based solution such as Azure SQL, MySQL, Azure Oracle in VM, AWS Aurora, or AWS RDS. • Excellent written and verbal communication skills, with both technical and non-technical audiences. • Experience analyzing requirements, researching alternatives, and making successful recommendations for database solutions. • Experience developing and executing successful migration plans from one database solution to another (e.g., Maria DB to MY SQL, Oracle to Azure SQL, not from one Oracle DB to another Oracle DB). • Demonstrated knowledge and successful execution of the principles and techniques of the full database design, modeling, development, testing, and documentation lifecycle. • Demonstrated knowledge and successful execution of the principles and techniques of systems implementation, including conversion, data reconciliation, and documentation. • Experience developing and documenting relational database models, based on functional specifications and conceptual object models. • • Experience developing and documenting database schemas based on relational models. • Experience building and deploying relational databases based on database design, models, and schemas. • Experience administering relational databases and conducting performance optimization to meet SLAs. • Experience analyzing database configuration to research and resolve database and application issues. • Extensive experience with function and stored procedure packages using SQL. • Experience with database performance monitoring and tuning tools and techniques. • Experience developing data scrubs to correct data based on knowledge of the application. Additional Skills/Qualifications Desired: • Experience with software and tools used by the Judicial Council IT office including, ERwin Data Modeler, Toad, Eclipse, JIRA, Clear Quest, and Subversion.
Pratap K.V’s Post
More Relevant Posts
-
Hello Professionals, Hope you all are doing well. Title: DB2 DBA Location: Pleasant Prairie, WI (Onsite) (Must Need Local) Below is the DB2 DBA role job description. 10 + Years of experience in DB2 DBA with Replication Expertise in Database Installation and Configuration: Installing and configuring Db2 LUW ( (Linux/Unix/Windows platform) database software on servers. Proficiency in performance tuning, backup and recovery, security management and troubleshooting Experience in database design, patch and version management. Knowledge in capacity Planning, documentation, collaboration, automation monitoring, compliance with relevant regulations and standards. Experience in Disaster Recovery Planning to minimize data loss in the event of a system failure. Provides status report updates to managers. Please share suitable profiles to email: shaikbashad@srsconsultinginc.com #c2crequirements #usajobseekers #usastaffing #usrecruiters #hotlist #email #consultants #share #java #javadeveloper #recruiter #jobs #support #cpt #opt #h4ead #gcead #citizens #data #java #developer #etl #teradata #analyst #sapfiori #sap #trending #dailypost #updates #jobupdates #jobalert #career #placements #engineer #qa #devops #salesforce #datascientist #interview #marketing #technology #team #business #bigdata #project #training #automation #automation #scrum #android #hadoop #python #machinelearning #sql #work #consultants #email #help #recruiters #hiring #jobs #resume #email #vendorlists #vendors #distributions #corp2corp #recruiting #hotlist #benchsales #vendorempanelment #recruiterjobs #jobopening #benchsalesrecruiter #benchsale #requirements, #recruiting #jobsearch #jobsearch #hiring #recruiting #cv #jobseekers #corp2corp #C2C #marketing #seo #email #requirements #dataengineer #hadoop #bigdata #jobs #ecommerce #website #accounting #resume #recruitment #databases #staffing #hotlist #resources #talentacquisition #recruitment #vendors #suppliers #c2c #vendormanagement #candidates #recruiting #itrecruiters #itstaffing #corp2corp #contractual #corptocorp #jobs #candidatessearching #recruiters #hotlist #c2crequirements #availableconsultants #healthcare #salesforce #data #staffing #resources #talentacquisition #email #recruitment #details #shares #vendors #suppliers #cpt #c2c #staff #connections #itbenchmarking #vendormanagement #updating #candidate #corps #recruiting #itrecruiters #itstaffing #contractual #jobs #candidatessearching #recruiters #hotlist #c2crequirements #availableconsultants #vendorlist #requirements #vendorempanelment #h1bvisa #jobsearch #opt #gc #subcontractors #benchsales #daily #matching #hiring #systemintegrators #marketing #jobseeking #lettings #benchmarking #vendor #recruiterjobs #LinkedIn #Resumesearch #Passivesearch #Recruitment #global #Unitedstates #usa #notes #search #resumes #requirement #vms #database #hotlist #bdm #usstaffing #benchsales #itstaffing #vendors #itrecruiter #usrecruitment #c2c
To view or add a comment, sign in
-
Hello Connections!! We are currently hiring for Oracle L3/L2 Position for our client. Job Location: PAN INDIA Timings: 24*7 REQUIREMENTS: 5-8 Years of relevant experience for L2; 8+ Years for L3 Experience with very large databases and/or data warehousing. Good knowledge of Oracle on AWS Linux Server Experience with High Availability and Always on Databases RESPONSIBILITIES: Database user account management: o DB account creation o Grant access rights on SYS and non-SYS objects o Permission on folders, log/trace files to Apps DBA o Define and manage user profiles/policies oDatabase Software maintenance: o Implement database patches in non-production and production environment; execute test plan, and rollback if necessary. Database Monitoring: o Monitor database log files for errors. o Monitor database components affecting connectivity e.g., listeners process and log. o Monitor database backups o Monitor database related OS/network parameters o Monitor free space availability on the database server · Manage Database Capacity: o Monitor growth rate of database objects and proactively resolve space related errors. o Monitor RDBMS log files and archive them in a timely fashion o Monitor mount points to keep free space available on which RDBMS files and database files are located. o Relocate physical database objects, for example, datafile, index, UNDO files, as necessary to manage space on the server. Manage Database Availability: o Ensure availability of instance/database, listeners, log files, space of log files, and other RDBMS related processes. o Database Maintenance: o Perform re-indexing as necessary to improve database performance. o Generate statistics as needed for improved program, for example, run Analyze statement in Oracle. o Tune database parameters to improved performance Manage Database Backup and Recovery: o Plan and execute backup and recovery process for production and non-production databases by utilizing Customer’s backup infrastructure. o Troubleshoot database backup issues o Perform database restore from backup as requested by Customer · Database High Availability management: o Provide support for HA technologies like Oracle RAC, SQL Cluster, Log shipping, ASM, Oracle Clusterware. o Provide support for database replication technologies. o Provide support for disaster recovery database technologies, for example, Oracle Dataguard, database mirroring, Always ON. o Provide support for Oracle Grid Control tool. o Perform refresh/cloning/rebuilding of database o Create new database/instance; Database software installation: o Estimate size and create directory structure on the server for RDBMS installation o Install and configure database software o Install and configure HA such as Oracle RAC or Microsoft SQL Cluster #panindiahiring #panindia #oracle #linux #rdbms #oraclejobs #informationtechnologyjobs
To view or add a comment, sign in
-
As a SQL developer working for a software company that provides database services, when your first client approaches you and requests a database system for their data, there are several steps you would typically follow: 1. Gather Requirements: Begin by having detailed discussions with the client to understand their specific needs and requirements. Determine the size of the data, the expected growth rate, the types of data they'll be storing, any specific functionalities they need (e.g., data querying, reporting, security measures), and their performance expectations. 2. Design the Database Schema: Based on the gathered requirements, you will design the database schema. This involves defining the tables, their fields, data types, relationships between tables, and any necessary constraints (e.g., primary keys, foreign keys) to ensure data integrity. 3. Choose the Database Management System (DBMS): Select the appropriate database management system based on the client's requirements and budget. Common choices include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, etc. Consider factors like scalability, performance, and compatibility with the client's existing infrastructure. 4. Set Up the Database: Install and configure the chosen DBMS on the client's servers or cloud environment. Create the necessary database and user accounts with appropriate permissions. 5. Data Migration (if applicable): If the client has existing data that needs to be migrated to the new system, plan and execute a data migration strategy to ensure a smooth transition without data loss or corruption. 6. Develop Data Access and Management APIs: Create APIs and interfaces that allow the client's applications to interact with the database securely. This may involve building CRUD (Create, Read, Update, Delete) operations and other custom functionalities. 7. Implement Security Measures: Implement security measures to protect the database from unauthorized access, such as setting up user authentication, encryption, and role-based access control. 8. Optimize Performance: Fine-tune the database and queries to ensure optimal performance. Indexing, query optimization, and database tuning may be necessary to meet the client's performance expectations. #JobOpportunity #NowHiring #DatabaseServices #SQLDeveloper #SoftwareJobs #TechJobs #JobOpening #CareerOpportunity #DatabaseManagement #ITJobs #TechTalent #JobPosting #CareerGrowth #JoinOurTeam #LinkedInJobs #TechIndustry #TechCareers #JobSearch #HiringNow #JobAlert #JobSeekers #CareerAdvancement #JobListing #TechCommunity #JobSeeking #JobOpportunities #HiringTalent #JobFair #CareerProgression #JobApplication
To view or add a comment, sign in
-
⚡🅷🅸🆁🅸🅽🅶!⚡ 𝗦𝗲𝗻𝗶𝗼𝗿 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗔𝗱𝗺𝗶𝗻𝗶𝘀𝘁𝗿𝗮𝘁𝗼𝗿 🗺️ 𝑳𝒐𝒄𝒂𝒕𝒊𝒐𝒏: 𝖥𝗎𝗅𝗅𝗒 𝖱𝖾𝗆𝗈𝗍𝖾 (In the EU) 🗎 𝙍𝙚𝙨𝙥𝙤𝙣𝙨𝙞𝙗𝙞𝙡𝙞𝙩𝙞𝙚𝙨 🗎 - Full Administration of MySQL (Percona 5.7) / MariaDB - Searching for non-consistent data and adding checks to prevent similar cases in the future - Reviewing new code that relates to changes in the way the database works - Proactive monitoring and performance troubleshooting - Accountability for the high critical environments - Development of an extensive replication scheme - Automation for DB tasks - Improving Database infrastructure (deploy and maintain column-oriented DB, Cloud DWH engines) - Adherence to ITIL key principles: change management, approval procedures, etc - Maintenance of documentation and inventory up to date - Setting up backups, and monitoring workload of the database. 🧑💻𝑻𝒆𝒄𝒉 𝒔𝒕𝒂𝒄𝒌;- 𝖫𝗂𝗇𝗎𝗑 𝖤𝗇𝗏𝗂𝗋𝗈𝗇𝗆𝖾𝗇𝗍, 𝖬𝗒𝖲𝖰𝖫, 𝖬𝖺𝗋𝗂𝖺𝖣𝖡, 𝖯𝗈𝗌𝗍𝗀𝗋𝖾𝖲𝗊𝗅, 𝖳𝖢𝖯/𝖨𝖯 𝗇𝖾𝗍𝗐𝗈𝗋𝗄𝗂𝗇𝗀, 𝖬𝗈𝗇𝗀𝗈𝖣𝖡/𝖢𝗅𝗂𝖼𝗄𝗁𝗈𝗎𝗌𝖾, 𝖯𝗋𝗈𝗆𝖾𝗍𝗁𝖾𝗎𝗌, 𝖡𝗂𝗀𝖰𝗎𝖾𝗋𝗒. 𝘐𝘧 𝘵𝘩𝘪𝘴 𝘪𝘴 𝘪𝘯𝘵𝘦𝘳𝘦𝘴𝘵𝘪𝘯𝘨 𝘧𝘰𝘳 𝘺𝘰𝘶 𝘨𝘦𝘵 𝘪𝘯 𝘤𝘰𝘯𝘵𝘢𝘤𝘵 - 𝘙𝘦𝘧𝘦𝘳𝘳𝘢𝘭𝘴 𝘸𝘦𝘭𝘤𝘰𝘮𝘦! 𝕃𝕚𝕝𝕪.𝕛𝕦𝕟𝕥𝕣𝕒𝕤𝕒𝕡𝕥@𝕫𝕗𝕩.𝕔𝕠𝕞
To view or add a comment, sign in
-
-
Talent Acquisition Executive|| Tech Recruitment certification || Employee Branding || Application Tracker System(ATS)|| Zoho, Oorwin || Workday Recuritment Linkedin assessment Certification
Share your Resume
Talent Acquisition Executive|| Tech Recruitment certification || Employee Branding || Application Tracker System(ATS)|| Zoho, Oorwin || Workday Recuritment Linkedin assessment Certification
Hi Connections, Looking for SQL Server DBA Exp- 5-8 years Location-Bangalore share email-asha_ms@carrieraconsulting.com Interview Face to Face JD- We are seeking a SQL Server DBA to join our Managed Services practice. As a member of this practice, you will communicate and consult with our client's business and technical personnel, blending with their IT team and working together to help identify potential problems and develop solutions. Candidate should be highly experienced with Microsoft SQL Server administration and database systems architecture. This position will focus on database expertise in both development and production support roles. SUMMARY OF RESPONSIBILITIES have experience with: • High-Availability design and builds using technologies SQL Server Failover Clusters • Database, system and application performance tuning • Replication and Cloning Design and Solutions • Database upgrades and migrations • Backup recovery plans and execution • Data integration (SSIS), analytics (SSAS), business intelligence (SSRS), and visualization. • SQL Server on Azure: - IaaS and PaaS EXPERIENCE REQUIREMENTS SQL Server DBA that has the following skill sets: A minimum of 5-8 years’ experience with the following is required: • Experience in providing 24x7 support and on-call rotation. • Ability to multi-task while maintaining high quality deliverables. • Install and configure new Microsoft SQL Server instances. • Should have experience in database design, installations, and conversions Responsible for database backup and recovery procedures, access security, and database integrity. • Experience in Database Performance, Maintenance, and automate SQL server tasks. • Install SQL Server service packs and updates. • Configure and manage SQL Security settings. • Make system design recommendations according to Microsoft SQL Server best practices. • Good hands-on experience with all High availabilities (Log shipping, Mirroring, Replication, Always On & Clustering), DR planning & troubleshooting of all HA issues. • Troubleshoot SQL server and application sluggishness and poor performance. • Hands on experience in performing database version upgrades and Edition upgrades. • Experience with SSIS & SSRS is a must. • Extensive knowledge of SQL and SQL server tools. • Hands on experience in migrating databases from On-prem to Cloud. • Prior experience with any of the cloud services (AWS, Microsoft Azure) is a must. • Flexible, team player, “get-it-done” personality. • Excellent written and verbal communication. • Ability to work in a rapidly changing environment. • MCTS, MCITP, and/or MVP certifications a plus. Experience identified below are additional positives: • Supporting multi-site environment • Experience with virtualization technologies. • Experience with Idera, Cohesity and Commvault • Experience with using ServiceNow. • Previous MSP experience • Experience with Azure, Oracle Cloud, Google Cloud, and/or AWS. Asha MS
To view or add a comment, sign in
-
#jobalert we are hiring for Oracle migration with Ms SQL server database Location: Hyderabad 10+ yrs of experience Email: adiba@vmultiply.com ________________________________ MS SQL Server DBA. Here is the JD- Microsoft SQL Server DBA ✓ ORACLE Database✓ Consolidate license and convert to SQL Server ✓ Microsoft SQL Server✓ Deployment to AWS cloud and Enhancement on Data Governing, Optimization and Archiving. ✓ MongoDB Database✓ Decommission PostgreSQL Database✓ Deployment to AWS and operate as non-critical business purpose such as Reporting Database Our primary objective is moving away dependency on ORACLE running on Windows environment. We would like to see all our business operate under Microsoft SQL Server with PostgreSQL as reporting database for simplified technology stack. We would like this person help to complete this journey with following. Managing and enforce database security with Active directory. Managing data encryption and data masking for sensitive customer data. Managing database change control process for both SOX and non-SOX system. Managing database backup and restore if needs. Managing data replication between data center and AWS cloud and other partner’s database. Managing data archive with database partition on monthly level. Managing database refresh between production and non-production environment to support development. Managing database performance with weekly report on CPU, Memory, and IO trending. Managing database DR site. Helping developers for query performance tuning if needs. #oracledba #sqldba #databases #migration #aws #azure #hyderbad #immediatejoiners
To view or add a comment, sign in
-