Skip to content

Instantly share code, notes, and snippets.

@phudgins
Created January 5, 2012 20:04
Show Gist options
  • Save phudgins/1566966 to your computer and use it in GitHub Desktop.
Save phudgins/1566966 to your computer and use it in GitHub Desktop.
Remove non-UTF8 chars from a string
require 'active_support/core_ext/string'
str = "<p>Seeking self-motivated Senior SQL Server DBA who will work closely with development teams and support the enterprise databases for four automotive businesses.</p> <p>  </p> <p> We are seeking a team player, who is a great communicator, that is well versed in SQL Server 2005 and 2008.</p> <p>  </p> <p> This person should possess skills in SQL Server database administration including: performance tuning, backup and recovery, log shipping, and T-SQL.</p> <p>  </p> <p> With limited supervision, the Sr DBA will be responsible for:</p> <p>  </p> <ul> <li> The administration and maintenance of Enterprise level SQL Server 2005 and 2008 database systems for three Dominion companies supplying websites and CRM tools for automotive dealerships in an environment requiring 24 X 7 up time</li> <li> The management and administration of 30+ TB of data in a NetApp/EMC SAN environment in two hosting facilities</li> <li> Excellent internal customer service and decision-making ability in the support of Database Operations for four business</li> <li> Maintaining and developing database monitoring, a backup and recovery strategy, and a disaster recovery strategy</li> <li> Performing basic project management for database level tasks with development teams and the Dominion hosting division</li> <li> Performing basic MySQL database administration to a pair of smaller applications</li> <li> Utilizing analytical reasoning abilities and collaboration efforts in troubleshooting issues with the various development teams</li> </ul><p>  </p> <p> Requirements:</p> <p>  </p> <ul> <li> 3 years experience in SQL Server database administration in a production environment with 24 X 7 up time requirements</li> <li> Excellent communicator and team player</li> <li> Proficient with monitoring tools both within SQL Server and 3rd party such as LiteSpeed and RedGate</li> <li> Experience with databases hosted on SANs</li> <li> Experience in managing large quantities of data on SANs across production and disaster recovery site</li> <li> Microsoft certifications a plus</li> <li> Provide after-hours on call support</li> </ul><p>  </p> <p> For consideration</p>"
str = str.chars.select {|c| c.ord.chr.is_utf8? }.join("")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment